join orcl的left_Oracle Left join right jion

1.left join(左联接)

sql语句如下:

SELECT * FROM

a LEFT JOIN b

ON a.akey =b.bkey

结果说明:

left join是以A表的记录为基础的,A可以看成左表,B可以看成右表.

left join是以左表为准的.

换句话说,左表(A)的记录将会全部表示出来,而右表(B)只会显示符合搜索条件的记录(例子中为: A.akey = B.bkey).

B表记录不满足条件的均为NULL.

2.right join(右联接)

sql语句如下:

SELECT * FROM a

RIGHT JOING b

ON a.akey = b.bkey

结果说明:

right join和left join的结果刚好相反,right join是以右表(B)为基础的,A表不满足条件的用NULL填充.

----------------------------------------------------------------------------------------------------------------

pxboracle@live.com

2014.05.06 17:01