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,是提示错误的!
怎么解决问题??知道的指点迷津,不知道的也思考下,共同学习!

这个不能用就用where子句呗

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

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')))