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 #test values(2)
insert into #test values(3)
insert into #test2 values(3)
insert into #test2 values(4)
insert into #test2 values(5)


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