Oracle左(外)、右(外)、全(外)、(内)连接语法与SQL标准的比较
==========================================================
/** 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;
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余1页未读,立即下载