22,209
社区成员
发帖
与我相关
我的任务
分享
select A.UID,B.* from B left join A on isnull(B.UID,-1)=A.ID
你要什么?
DECLARE @a table(a INT,b int)
INSERT @a SELECT NULL,1
INSERT @a SELECT 1,1
INSERT @a SELECT 2,1
DECLARE @b table(a INT,b int)
INSERT @b SELECT 1,1
INSERT @b SELECT 8,1
SELECT * FROM @a a LEFT JOIN @b b ON isnull(a.a,-1)=b.a
--result
/*
a b a b
----------- ----------- ----------- -----------
NULL 1 NULL NULL
1 1 1 1
2 1 NULL NULL
*/
select * from b left join a on isnull(uid,-1)=a.id
select b.*,a.* from b left join a on isnull(uid,-1)=a.id