Query Problem

From: Abdul Wahab Dahalan <wahab(at)mimos(dot)my>
To: pgsql-sql(at)postgresql(dot)org
Subject: Query Problem
Date: 2005-04-07 07:16:26
Message-ID: 5039595.1112858186520.SLOX.WebMail.wwwrun@openx.mimos.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2005-04-07 08:46:09 Re: Query Problem
Previous Message Dinesh Pandey 2005-04-07 05:00:30 Re: ar: Command not found.