22,206
社区成员
发帖
与我相关
我的任务
分享
declare @a table( id int)
declare @b table( id int)
declare @c table( id int)
insert @a select 1 union all select 2
insert @b select 1 union all select 2
insert @c select 1 union all select 2
select * from @a a
left join @b b on a.id = b.id
left join @c c on a.id = c.id