|
#2
来自北方的狼2007-12-14 09:18
|
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,是提示错误的!
怎么解决问题??知道的指点迷津,不知道的也思考下,共同学习!