Oracle8
select a.*,b.* from a,b where a.id(+)=b.id --相当于左联接
select a.*,b.* from a,b where a.id=b.id(+) --相当于右联接
Oracle9
支持以上的写法，还增加了LeftJoin、Right Join等
select a.*,b.* from a left join b on a.id=b.id
select a.*,b.* from a right join b on a.id=b.id
Sqlserver
select a.*,b.* from a,b where a.id *= b.id --相当于左联接
select a.*,b.* from a,b where a.id =* b.id --相当于右联接
select a.*,b.* from a left join b on a.id=b.id
select a.*,b.* from a right join b on a.id=b.id
自己的一些经验，保存下来
|