If I've 2 tables like this:
Country table : with 2 fields (country and id)
Country id
England E
France F
Japan J
FlightTo table : with 2 fields(Flight ID and Destination)
FlightID Destination
B1 E,J
B2 E,F
B3 J,F
How do I make a query, so that I can get a result something like this :
FlightID CountryVisited
B1 England,Japan
B2 England,France
B3 Japan, France
Any help very much appreciated. Thanks
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
