join example

0

Please login or register to vote for this query.

(click on this box to dismiss)

Reverse Engineering Meta

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

create table #test (
id int
)

create table #test2 (
id int
)

insert into #test values(1)
--insert into #test2 values(1)


select * from #test
FULL join #test2 on #test.id = #test2.id

drop table #test
drop table #test2

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results