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