22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT HubID,FactoryID,dtu.DTUID,DeviceName,dtu.projectid,dtu.isdel
FROM tDTU dtu
left join tHubControl hub
on dtu.DTUID=hub.DTUID and dtu.IsDel = 0 and hub.IsDel = 0
--等同于
SELECT HubID,FactoryID,dtu.DTUID,DeviceName,dtu.projectid,dtu.isdel
FROM tDTU dtu
left join (select * from tHubControl where IsDel=0 and IsDel) hub
on dtu.DTUID=hub.DTUID