Easy Tutorial
❮ Programmer Joke 14 Android Tutorial Webview Error Code ❯

English:

One Diagram to Understand the Various Uses of SQL JOINs

Category Programming Techniques

The following diagram shows 7 different uses related to LEFT JOIN, RIGHT JOIN, INNER JOIN, and OUTER JOIN.

Inner JOIN

SELECT <select_list> 
FROM Table_A A
INNER JOIN Table_B B
ON A.Key = B.Key

Left JOIN

SELECT <select_list>
FROM Table_A A
LEFT JOIN Table_B B
ON A.Key = B.Key

Right JOIN

SELECT <select_list>
FROM Table_A A
RIGHT JOIN Table_B B
ON A.Key = B.Key

Outer JOIN

SELECT <select_list>
FROM Table_A A
FULL OUTER JOIN Table_B B
ON A.Key = B.Key

Left Excluding JOIN

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

Right Excluding JOIN

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

Outer Excluding JOIN

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

>

For more information, please refer to the SQL Tutorial

** Click to Share Notes

Cancel

-

-

-

❮ Programmer Joke 14 Android Tutorial Webview Error Code ❯