LATERAL joins let a subquery in the FROM clause reference columns from earlier in the same FROM clause. Semi joins return rows where a match exists in another table, without duplicating those rows. Anti joins return rows where no match exists.
Cet article est paru en premier sur le site https://www.kdnuggets.com/advanced-join-techniques-lateral-joins-semi-joins-anti-joins