Languages
[Edit]
EN

PostgreSQL - JOIN list + SQL Query

0 points
Created by:
Wade
352

PostgreSQL - JOIN list + SQL Query

VisualisationSQL Query

INNER JOIN

SELECT *
FROM table_a A
JOIN table_b B ON A.key = B.key

LEFT OUTER JOIN

SELECT *
FROM table_a A
LEFT JOIN table_b B ON A.key = B.key

RIGHT OUTER JOIN

SELECT *       
FROM table_a A
RIGHT JOIN table_b B ON A.key = B.key

FULL OUTER JOIN

SELECT * FROM table_a A
FULL OUTER JOIN table_b B ON A.key = B.key

LEFT OUTER JOIN with exclusion

SELECT  *
FROM table_a A
LEFT JOIN table_b B ON A.key = B.key
WHERE B.key IS NULL

RIGHT OUTER JOIN with exclusion

SELECT *
FROM table_a A
RIGHT JOIN table_b B ON A.key = B.key
WHERE A.key IS NULL

FULL OUTER JOIN with exclusion

SELECT * FROM table_a A
FULL OUTER JOIN table_b B ON A.key = B.key
WHERE B.key IS NULL OR A.key IS NULL

PostgreSQL

Native Advertising
ūüöÄ
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

‚̧ԳŹūüíĽ ūüôā

Join