Join one to many relationship, select one row per the one on some criteria

one_to_many_join.sql

-- one customer to many transactions
-- want to select most recent transaction for each customer

select * from customers join transactions on transactions.id = (
    select id from transactions
    where transactions.customer_id = customers.id
    order by created_at desc
    limit 1
)