How do I limit Left join to 1?
How do I limit Left join to 1? To get one per group to join against, you can use an aggregate MAX() or MIN() on the movie_id and group it in the subquery. No subquery LIMIT is then necessary — you’ll receive the first movie_id per name with MIN() or the last with MAX() . […]