Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence
create table #test ( id int ) create table #test2 ( id int ) insert into #test values(1) insert into #test values(4) insert into #test2 values(1) insert into #test2 values(2) insert into #test2 values(3) select * from #test join #test2 on #test.id = #test2.id drop table #test drop table #test2