Get the App
SLTechnology News&Howtos  ›  Database  › 

How to use Join in SQL

Shulou Source: shulou.com Published: 2022-05-31 21:42:30 11月16日 Update

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.

Tags: Content more help good interest boys buddies articles knowledge articles references Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno NVidia Apple Shulou Information Docker MariaDB