select A.*,B.*,C.* from A
left join B on A.PID=B.PID
left join C on A.BID=C.BID
select * from EVW_EMPLOYEE e left join oDepartment d on e.DPID=d.DPID left join oJob j on e.JBID=j.jbid where e.status = 1 and e.EZID=105 order by e.badge
冥河(提问者)多问一下，后面多了筛选条件 A.status = 1 and A.EZID=105，这个在这个连接语句是写在哪里的呢？
我这样写了，然后都没起作用
select * from EVW_EMPLOYEE e
left join oDepartment d on e.DPID=d.DPID and e.status = 1 and e.EZID=105
left join oJob j on e.JBID=j.jbid
order by e.badge
1min目标场景问卷
立即参与
