34,593
社区成员
发帖
与我相关
我的任务
分享
SELECT
DeviceID
,DeviceName
,TB_Worker.WorkerName
FROM TB_Device LEFT JOIN TB_Worker
ON TB_Device.WorkerID=TB_Worker.WorkerID
ORDER BY DeviceID ASC
SELECT
DeviceID
,DeviceName
,(SELECT WorkerName FROM TB_Worker WHERE TB_Worker.WorkerID=TB_Device.WorkerID)
,(SELECT WorkerName FROM TB_Worker WHERE TB_Worker.WorkerID=TB_Device.WorkerID2)
FROM TB_Device
ORDER BY DeviceID ASC
SELECT
t1.DeviceID
,t1.DeviceName
,t2.WorkerName
,t3.WorkerName
FROM TB_Device AS t1
INNER JOIN TB_Worker as t2 ON t1.WorkerID=t2.WorkerID
INNER JOIN TB_Worker as t3
ON t1.WorkerID=t3.WorkerID
ORDER BY t1.DeviceID ASC
SELECT
DeviceID
,DeviceName
,tbwk1.WorkerName
,tbwk2.WorkerName
FROM TB_Device
LEFT JOIN TB_Worker as tbwk1
ON TB_Device.WorkerID=tbwk1.WorkerID
LEFT JOIN TB_Worker as tbwk2
ON TB_Device.WorkerID=tbwk2.WorkerID
ORDER BY DeviceID ASC
select DeviceID,DeviceName,WorkerName,WorkerName2 from(
select DeviceID,DeviceName,WorkerName,WorkerID2 from TB_Device a
left join TB_Worker b on a.WorkerID=b.WorkerID)t
left join TB_Worker s on t.WorkerID2=s.WorkerID