左外连接用left join,右外连接用right join语句。比如Oracle:select * from a, b where a.id=b.id(+)SQL:select * from a left join b on a.id=b.id反过来a.id(+)=b.id 就是right join