Posted by laredotornado on 03/02/06 21:28

Hi, Using MySQL 4, is it possible (and how) would I write a single
query to look at the following tables

CRUISES
CRUISE_ID CRUISE_NAME
---------------- ----------------------
1 Atlantic Cruise
2 Pacific Cruise

CRUISE_STOPS
CRUISE_ID DEPART_TIME DEPARTURE_NAME
----------------- ---------------------
-------------------------------
1 4/1/2006 8:00 Miami
1 4/15/2006 9:00 Virginia Beach
2 8/1/2006 11:00 San Francisco
2 8/31/2006 8:00 Mexico

and return the first depart ponit on the cruise. So the single query
would return the following results

CRUISE_ID CRUISE_NAME DEPARTURE_NAME
---------------- ------------------------
-------------------------------
1 Atlantic Cruise Miami
2 Pacific cruise San Francisco

Thanks for your help, - Dave

[Back to original message]