Posted by strawberry on 10/13/52 11:41

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]