摘要：
Oracle8select 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.idselect a.*,b.* from aright join b on a.id=b.idSqlserverselect a.*,b.* from a,b where a.id *= b.id --相当于左联接 阅读全文
