22,209
社区成员
发帖
与我相关
我的任务
分享
select c1.*,d.d1,a.a1.b.b1 from c left join a on a.machineid=c.machineid
left join b.routinid=c.routinid left join d on (c.routinid=d.routinid and d.machineid=c.machineid)
好像left join不支持on (c.routinid=d.routinid and d.machineid=c.machineid)