Q&A about the site for music historians, critics, and fans
create table #test ( id int ) create table #test2 ( id int ) insert into #test values(1) insert into #test2 values(1) select * from #test left outer join #test2 on #test.id = #test2.id drop table #test drop table #test2