📺 All 44 POSETTE: An Event for Postgres 2026 talks are now available on YouTube.
Our beloved Structured Query Language may be the lingua franca for relational databases—but like many languages, SQL is in a state of constant evolution. The first releases of SQL didn't even have a notation for joins. At the time, SQL only supported inner joins.
Cross Joins and Where Filters
As a result, back in early eighties, the only way to express a join condition between tables would be in the WHERE clause.
Keep reading