I have two tables: boats and crew. I need to select some boats (not a problem) and to join the crew table but I want to pick only one crew member per boat and not just any crew member but one selected by sorting the crew table.

In other words, I need to do a sub select on the crew table that yields at most one record per boat and to join the result to the select from the boats table. How can this be done?