– 左连接通用写法:select * from a left join b on a.id=b.id – 右连接通用 写法:select * from a right join b on a.id=b.id – 全连接通用 写法:select * from a full join b on a.id=b.id – 左连接Oracle 写法:select * from a,b where a.id=b.id( ) – 右连接Oracle 写法:select * from a,b where a.id ( ) =b.id本回答被网友采纳