Postgres Pro
Downloads
Home   >   mailing lists

Query Problem - Mailing list pgsql-sql

From Abdul Wahab Dahalan
Subject Query Problem
Date
Msg-id 5039595.1112858186520.SLOX.WebMail.wwwrun@openx.mimos.my
Whole thread Raw
Responses Re: Query Problem  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Dinesh Pandey"
Date:
Subject: Re: ar: Command not found.
Next
From: Richard Huxton
Date:
Subject: Re: Query Problem