Re: How to select last event from a related table

[Peter Brawley]

Is this what you mean?

select order_id, max(created_at) as last_event
from events e
join orders o on e.order_id=o.id
group by order_id
order by order_id;