Database Reference
In-Depth Information
Without the keyword, PostgreSQL might end up performing a join with unintended
results.
Other database products also offer lateral joins, although they don't abide by the ANSI
moniker. In Oracle, you'd use a table pipeline construct. In SQL Server, you'd use
CROSS
APPLY
or
OUTER APPLY
.
