declare @a table(a int,b int) declare @b table(a int,b int) insert @a values(1,1) insert @a values(2,2) insert @b values(1,1) insert @b values(3,3)--左: select * from @a Aa left join @b Bb on Aa.a=Bb.a --右: select * from @a Aa right join @b Bb on Aa.a=Bb.a --内 select * from @a Aa join @b Bb on Aa.a=Bb.a --外 select * from @a Aa full join @b Bb on Aa.a=Bb.a --完全 select * from @a,@b
select a.*,b* from a,b where a.id=b.id
新手上路:一开始学sql 2000 应看什么资料就可以了
例子: 用条件 select a.*,b.*,c.* from a,b,c where a.id=b.id and a.id=c.id或者用连接 select a.*,b.*,c.* from a inner join b on a.id=b.id inner join c on a.id=c.id
declare @b table(a int,b int)
insert @a values(1,1)
insert @a values(2,2)
insert @b values(1,1)
insert @b values(3,3)--左:
select * from @a Aa left join @b Bb on Aa.a=Bb.a
--右:
select * from @a Aa right join @b Bb on Aa.a=Bb.a
--内
select * from @a Aa join @b Bb on Aa.a=Bb.a
--外
select * from @a Aa full join @b Bb on Aa.a=Bb.a
--完全
select * from @a,@b
用条件
select a.*,b.*,c.*
from a,b,c
where a.id=b.id and a.id=c.id或者用连接
select a.*,b.*,c.*
from a inner join b on a.id=b.id
inner join c on a.id=c.id