join example

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

create table #test (
id int
)

create table #test2 (
id int
)

insert into #test values(1)
insert into #test2 values(1)
insert into #test2 values(2)
insert into #test2 values(3)


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

drop table #test
drop table #test2

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results