Posted by Simon on 10/13/42 11:41

I don't see how this solves the problem.

All this does is select the first cruise_stop for each cruise in the natural
order of the cruise. It doesn't find the cruise_stop for the first departure
!


"strawberry" <zac.carey@gmail.com> wrote in message
news:1141486552.775111.321130@z34g2000cwc.googlegroups.com...
> Does GROUP BY work on 4? If so, turn the query around...
>
> SELECT cruises.cruise_id,cruise_name,departure_name
> FROM cruise_stops
> LEFT JOIN cruises ON cruise_stops.cruise_id = cruises.cruise_id
> GROUP BY cruises.cruise_id
> ORDER BY cruises.cruise_id
>

[Back to original message]