爱人 发表于 2007-12-13 09:09

DATAWINDOW 能不能用 连接 JION??

PB建立DW能不能用
left join lanwan.dq_js_grz
on       lanwan.hr_j_employeeinform.worker_code=lanwan.dq_js_grz.w_name
left join lanwan.dq_js_chshqk
on       lanwan.hr_j_employeeinform.worker_code=lanwan.dq_js_chshqk.w_name
left join lanwan.dq_js_marriage_certificate
on       lanwan.hr_j_employeeinform.worker_code=lanwan.dq_js_marriage_certificate.w_name
where    lanwan.hr_j_employeeinform.worker_code = lanwan.hr_j_familymember.worker_code
and      lanwan.hr_j_familymember.calls_code in ('10','11','12')
这样的语句建立DW啊?但是我这样建立DW,是提示错误的!
怎么解决问题??知道的指点迷津,不知道的也思考下,共同学习!

来自北方的狼 发表于 2007-12-14 09:18

这个不能用就用where子句呗

ugly927846 发表于 2007-12-15 11:16

可以的 ..........

爱人 发表于 2007-12-18 10:38

left join lanwan.dq_js_grz
on       lanwan.hr_j_employeeinform.worker_code=lanwan.dq_js_grz.w_name
left join lanwan.dq_js_chshqk
on       lanwan.hr_j_employeeinform.worker_code=lanwan.dq_js_chshqk.w_name
left join lanwan.dq_js_marriage_certificate
on       lanwan.hr_j_employeeinform.worker_code=lanwan.dq_js_marriage_certificate.w_name
where    ((lanwan.hr_j_employeeinform.worker_code = lanwan.hr_j_familymember.worker_code)
and      (lanwan.hr_j_familymember.calls_code in ('10','11','12')))

页: [1]

编程论坛