Posted by strawberry on 09/29/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

• Next in forum: Re: Tricky MySQL involving a join and a min
• Prev in forum: Re: Tricky MySQL involving a join and a min
• Thread view: Re: Tricky MySQL involving a join and a min

[Reply to this message]