derlare @t1 table(id int, col int) derlare @t2 table(id int, col int)insert @t1 select 1,10 union all select 2,12 union all select 3,14 insert @t2 select 1,10 union all select 1,12 union all select 3,14 select * from @t1 a left join @t2 b a.id=b.id
derlare @t1 table(id int, col int) derlare @t2 table(id int, col int)insert @t1 select 1,10 union all select 2,12 union all select 3,14 insert @t2 select 1,10 union all select 1,12 union all select 3,14 select * from @t1 a left join @t2 b on a.id=b.id
derlare @t1 table(id int, col int)
derlare @t2 table(id int, col int)insert @t1
select 1,10 union all
select 2,12 union all
select 3,14
insert @t2
select 1,10 union all
select 1,12 union all
select 3,14
select * from @t1 a left join @t2 b a.id=b.id
derlare @t1 table(id int, col int)
derlare @t2 table(id int, col int)insert @t1
select 1,10 union all
select 2,12 union all
select 3,14
insert @t2
select 1,10 union all
select 1,12 union all
select 3,14
select * from @t1 a left join @t2 b on a.id=b.id