/** left (outer) join */
/** Standard SQL Syntax */
select * from a left outer join b on a.id = b.id;
/** Oracle SQL Syntax */
select * from a, b where a.id = b.id(+);
/** right (outer) join */
* Standard SQL Syntax */
select * from a right outer join b on a.id = b.id;
/** Oracle SQL Syntax */
select * from a, b where a.id(+) = b.id;
/** (inner) join */
/** Standard SQL Syntax */
select * from a inner join b on a.id = b.id;
/** Oracle SQL Syntax */
select * from a, b where a.id = b.id;
/** (full) join */
/** Standard SQL Syntax */
select * from a full join b on a.id = b.id;
/** Oracle SQL Syntax */
select * from a, b where a.id = b.id(+) union select * from a, b where a.id(+) = b.id;