Re: Query Problem

Abdul Wahab Dahalan wrote:
> 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

Simplest solution is to correct this table - "Destination" should be two
fields (e.g. dest_from,dest_to). Then you could do something like:

SELECT
flight_id,
c1.country as from_country,
c2.country as to_country
FROM
flight_to,
country c1,
country c2
WHERE
dest_from = c1.id
AND dest_to = c2.id
;
--
Richard Huxton
Archonet Ltd