1.内连接
SELECT <select_list> FROM TableA A INNER JOIN TableB B ON A.Key = B.Key
2.左连接
SELECT <select_list> FROM TableA A LEFT JOIN TableB B ON A.Key = B.Key
3.右连接
SELECT <select_list> FROM TableA A RIGHT JOIN TableB B ON A.Key = B.Key
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