EN
MS SQL Server - JOIN list + SQL Query
0 points
| Visualisation | SQL Query |
|---|---|
|
|
INNER JOIN xxxxxxxxxx1 SELECT *2 FROM table_a A3 INNER JOIN table_b B ON A.key = B.key |
|
|
LEFT OUTER JOIN xxxxxxxxxx1 SELECT *2 FROM table_a A3 LEFT JOIN table_b B ON A.key = B.key |
|
|
RIGHT OUTER JOIN xxxxxxxxxx1 SELECT * 2 FROM table_a A3 RIGHT JOIN table_b B ON A.key = B.key |
|
|
FULL OUTER JOIN xxxxxxxxxx1 SELECT * FROM table_a A2 FULL JOIN table_b B ON A.key = B.key |
|
|
LEFT OUTER JOIN with exclusion xxxxxxxxxx1 SELECT *2 FROM table_a A3 LEFT JOIN table_b B ON A.key = B.key4 WHERE B.key IS NULL |
|
|
RIGHT OUTER JOIN with exclusion xxxxxxxxxx1 SELECT *2 FROM table_a A3 RIGHT JOIN table_b B ON A.key = B.key4 WHERE A.key IS NULL |
|
|
FULL OUTER JOIN with exclusion xxxxxxxxxx1 SELECT * FROM table_a A2 FULL OUTER JOIN table_b B ON A.key = B.key3 WHERE B.key IS NULL OR A.key IS NULL |
