34,576
社区成员
发帖
与我相关
我的任务
分享
select tt1.*,ID1,t1,t2,t3
from tt1 left join tt2 on tt1.id=tt2.id
SELECT [TT1.*],[TT2.ID1],[TT2.T1],[TT2.T2],[TT2.T3]
FROM [TT1] LEFT JION [TT2]
ON [TT1.ID]=[TT2.ID]
SELECT [TT1.*],[TT2.ID1],[TT2.T1],[TT2.T2],[TT2.T3]
FROM [TT1] LEFT JION [TT2]
ON [TT1.ID]=[TT2.ID]
select a.*,b.Id1,b.t1,b.t2,b.t3
from TT1 a
left join
TT2 b
on a.id=b.id1
SELECT TT1.*,TT2.ID1,TT2.T1,TT2.T2,TT2.T3
FROM TT1
LEFT JOIN TT2
ON TT1.ID=TT2.ID
or:
SELECT *
FROM TT1
ORTER APPLY(SELECT ID1,T1,T2,T3 FROM TT2 WHERE TT1.ID=ID) T
SELECT TT1.*,TT2.ID1,TT2.T1,TT2.T2,TT2.T3 FROM TT1
LEFT JOIN TT2
ON TT1.ID=TT2.ID
SELECT A.*,B.ID1,B.T1,B.T2,B.T3 FROM A LEFT JOIN B ON A.ID=B.ID
select a.*,b.Id1,b.t1,b.t2,b.t3
from TT1 a left join TT2 b
on a.id=b.id1