7种jion语句

1.内连接

SELECT <select_list> FROM TableA A INNER JOIN TableB B ON A.Key = B.Key

只显示a1=a2的共有的数据

2.左连接

SELECT <select_list> FROM TableA A LEFT JOIN TableB B ON A.Key = B.Key

左连接查出的数据，显示A表a1所有数据，B表没有与之对应的就为null

3.右连接

SELECT <select_list> FROM TableA A RIGHT JOIN TableB B ON A.Key = B.Key

右连接查出的数据，显示B表a2所有数据，A表没有与之对应的就为null。与左连接相反

4.带条件左连接

SELECT <select_list> FROM TableA A LEFT JOIN TableB B ON A.Key = B.Key WHERE B.Key IS NULL

5.带条件右连接

SELECT <select_list> FROM TableA A RIGHT JOIN TableB B ON A.Key = B.Key WHERE A.Key IS NULL

6.全连接

SELECT <select_list> FROM TableA A FULL OUTER JOIN TableB B ON A.Key = B.Key

7.带条件全连接

SELECT <select_list> FROM TableA A FULL OUTER JOIN TableB B ON A.Key = B.Key WHERE A.Key = B.Key WHERE A.Key IS NULL OR B.Key IS NULL