vicktor,
вот примеры
create table #t (a int, text1 nvarchar(10));
insert into #t values(1,'Animals');
insert into #t values(2,'People');
insert into #t values(3,'Birds');
insert into #t values(4,'Pets');
go
create table #t1 (b int, a int,text2 nvarchar(10));
insert into #t1 values(1,1,'Tiger');
insert into #t1 values(2,1,'Leopard');
insert into #t1 values(3,3,'Eagle');
insert into #t1 values(4,4,'Cats');
insert into #t1 values(5,4,'Dogs');
insert into #t1 values(6,5,'h1n1');
insert into #t1 values(7,5,'e2e4');
go
-- Cross join
select * from #t,#t1
-- join
select * from #t a,#t1 b
where a.a=b.a
-- Left join
select t.a,t.text1,t1.b,t1.text2 from #t as t
left join #t1 as t1 on t1.a = t.a
-- right join
select t.a,t.text1,t1.b,t1.text2 from #t as t
right join #t1 as t1 on t1.a = t.a