Contoh tabel:
- customer: id, name
- purchase: id, customer_id, item_id, date
Kita mau mengambil data customer dengan purchase terakhir
[code language=”sql”]
SELECT c.*, p1.*
FROM customer c
JOIN purchase p1 ON (c.id = p1.customer_id)
LEFT OUTER JOIN purchase p2 ON (c.id = p2.customer_id AND
(p1.date < p2.date OR p1.date = p2.date AND p1.id < p2.id))
WHERE p2.id IS NULL;
[/code]
