Oracle左(外)、右(外)、全(外)、(内)连接语法与SQL标准的比较

 

 

/** left (outer) join */

/** Standard SQL Syntax */

select*from a leftouterjoin 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 rightouterjoin 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 innerjoin 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 fulljoin 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;