oracle中的plsql where (+)用SQL如何實現？

比如

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