Shulou(Shulou.com)05/31 Report--

This article introduces how to use Join in SQL, the content is very detailed, interested friends can refer to, hope to be helpful to you.

1. INNER JOIN (internal connection)

SELECT FROM Table_A AINNER JOIN Table_B BON A.Key = B.Key

2. LEFT JOIN (left connection)

SELECT FROM Table_A ALEFT JOIN Table_B BON A.Key = B.Key

3. RIGHT JOIN (right connection)

SELECT FROM Table_A ARIGHT JOIN Table_B BON A.Key = B.Key

4. OUTER JOIN (external connection)

SELECT FROM Table_A AFULL OUTER JOIN Table_B BON A.Key = B.Key

5. LEFT JOIN EXCLUDING INNER JOIN (left connection-inner connection)

SELECT FROM Table_A ALEFT JOIN Table_B BON A.Key = B.KeyWHERE B.Key IS NULL

6.RIGHT JOIN EXCLUDING INNER JOIN (right connection-inside connection)

SELECT FROM Table_A ARIGHT JOIN Table_B BON A.Key = B.KeyWHERE A.Key IS NULL

7. OUTER JOIN EXCLUDING INNER JOIN (external connection-internal connection)

SELECT FROM Table_A AFULL OUTER JOIN Table_B BON A.Key = B.KeyWHERE A.Key IS NULL OR B.Key IS NULL on how to use Join in SQL to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.