subselect SQL*plus

From: Roger Langedal <roger.langedal_at_bergen.mail.telia.com>
Date: 1998/03/08
Message-ID: <3501fd2b.0@d2o202.telia.com>#1/1

I`trying to learn SQL, but I`m stuck at the last example I tried to solve.

This is the case.....

I have a table FLIGHTSCEDULE containing the columnnames:

This is what the tables look like:

TABLE1->>

                    FLIGHT        DEPARTING_FROM_CODE
ARRIVES_AT_CODE        TIME_OF_DEPATURE        TIME_OF_ARRIVAL
e.g:               SA231                       FBU
HTR                                        0900
1000
                      BA111                       CDG
GTW                                        1320

1430

TABLE2:
CONTAINS DATA IDENTIFYING THE TO AND FROM CODES... Table CITYCODE:

                                              CODE                    CITY

                                e.g:        HTR                    LONDON
                                              GTW                    LONDON
                                               CDG                    PARIS

I`m supposed to use a subquerie too list the flights from Paris to London....

As there are TO instances of London, I am not able find a way to select and return BOTH CDG(paris) - HTR(london) AND CDG(london)??!!

I hope ther is anybody out there who takes the time too look at this....

Roger Received on Sun Mar 08 1998 - 00:00:00 CST