PostgreSQL Joins: A Visual Explanation of PostgreSQL Joins

PHOTO EMBED

Wed Apr 14 2021 16:57:00 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira

SELECT
    a,
    fruit_a,
    b,
    fruit_b
FROM
    basket_a
FULL OUTER JOIN basket_b 
    ON fruit_a = fruit_b;
Code language: SQL (Structured Query Language) (sql)
content_copyCOPY

https://www.postgresqltutorial.com/postgresql-joins/