作者:傻缺缺的谭贱儿_452 | 来源:互联网 | 2023-09-15 18:06
三表连接SELECTa.ZDID,a.ZDname,a.ZDIP,a.Remark,b.eventtime,c.checkTimefrom(ZDListasaleftjoinZDE
三表连接
SELECT a.ZDID,a.ZDname,a.ZDIP,a.Remark,b.eventtime,c.checkTime from (ZDList as a
left join ZDEvents as b on a.zdid=b.zdid )
left join ZDcheckchangerecord_old as c on a.zdid=c.zdid