Skip to main content

lateral join

Short Description

The lateral join node indicates a correlated subquery with the of a FOR LOOP

Detailed Description

lateral joins are correlated subqueries that reference another query or subquery within its SELECT statement. Unlike normal correlated subqueries, LATERAL subqueries iterate through each row in the referenced query for each row in the inner. This behaviour is like a FOR LOOP.

Search online

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.