Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT c.*, p.*
- 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
Advertisement