EN
PostgreSQL - JOIN list + SQL Query
0 points
| Visualisation | SQL Query |
|---|---|
|
|
INNER JOIN xxxxxxxxxx1 SELECT *2 FROM table_a A3 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 OUTER 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 |
Alternative titles
- PostgreSQL - difference between inner / outer joins
- PostgreSQL - inner / outer joins explanation
- PostgreSQL - INNER JOIN
- PostgreSQL - LEFT OUTER JOIN
- PostgreSQL - RIGHT OUTER JOIN
- PostgreSQL - FULL OUTER JOIN
- PostgreSQL - LEFT OUTER JOIN with exclusion
- PostgreSQL - RIGHT OUTER JOIN with exclusion
- PostgreSQL - RIGHT OUTER JOIN with exclusion
