Example of full join and cross join
declare @tbl1 table (a1 int, b1 int)
declare @tbl2 table (a1 int, b1 int)
insert into @tbl1 values (1,2)
insert into @tbl1 values(5,6)
insert into @tbl1 values(3,4)
insert into @tbl2 values(11,22)
insert into @tbl2 values(55,66)
insert into @tbl2 values(33,44)
--full join
select * from @tbl1 a full join @tbl2 b on a.a1 = b.a1
--cross join
select * from @tbl1 cross join @tbl2
|
No responses found. Be the first to respond and make money from revenue sharing program.
|