Skip to content
masterclass Buddy
Start learning

PostgreSQL · Command

LATERAL

LATERAL lets a FROM subquery or table function use columns from an earlier FROM item. PostgreSQL evaluates it for each source row or row set and joins the results.

Last updated

Syntax

FROM source_table AS s
[INNER | LEFT] JOIN LATERAL (subquery) AS alias ON condition

In-depth API docs are only for subscribers: parameters, examples, common mistakes and interview practice.

Subscribe
  • FROM clause
  • JOIN
  • LEFT JOIN
  • CROSS JOIN
  • WHERE clause
  • set-returning function

Source: PostgreSQL: Documentation: 18: 7.2. Table Expressions. Checked 2026-11-03.