Click here for the Turkish version of the snippet.
SQL Lateral Join Sorguları
SELECT customers.*, recent_sales.*
FROM customers
LEFT JOIN LATERAL (
SELECT *
FROM sales
WHERE sales.customer_id = customers.customer_id
ORDER BY created_at DESC
LIMIT 3
) AS recent_sales ON true;
İLGİLİ MAKALELER
İLGİLİ KOD PARÇALARI