PostgreSQL - Joins in PostgreSQL
Given these tables:
ID | Name
1 | Alice
2 | Bob
4 | Diana
ID | City
2 | Paris
3 | London
4 | Berlin
What is the result of:
Table A:ID | Name
1 | Alice
2 | Bob
4 | Diana
Table B:ID | City
2 | Paris
3 | London
4 | Berlin
What is the result of:
SELECT COALESCE(A.ID, B.ID) AS ID, A.Name, B.City FROM A FULL OUTER JOIN B ON A.ID = B.ID ORDER BY ID;