8 ms·PostgreSQL's Powerful New Join Type: Lateral2 points by craigkerstiens 9y agoak39 9y agoT-SQL has this as CROSS APPLY and OUTER APPLY. Like pgsql’s LATERAL JOIN, CROSS APPLY has been a game changer in the way you think iteration in sets. Highly recommended.