⚡️ Database Tip
Sometimes you want to get e.g. the last three orders for ** customer. Normal joins can't do that. You have to execute n+1 queries in code, which is slow!
But with lateral joins, you can do one for-each loop join in SQL 🤯
Posted 2 years ago (16 November 2022)