home *** CD-ROM | disk | FTP | other *** search
/ Programming Languages Suite / ProgramD2.iso / Visual Database / Visual dBase Pro v7.0 / DATA1.CAB / Sample_dBASE / Fleet / Ftree.sql < prev    next >
Encoding:
Text File  |  1997-11-20  |  452 b   |  7 lines
  1. --Database:FLEET
  2. SELECT Aircraft."Aircraft ID", Aircraft.MAKE, Aircraft.MODEL, Schedule."Aircraft ID", Schedule."Flight Date", Schedule."Flight ID", Flight."Flight ID", Flight."From ID", Flight."To ID", Flight.DEPARTS, Flight.ARRIVES
  3. FROM "schedule.dbf" Schedule
  4.    INNER JOIN "flight.dbf" Flight
  5.    ON  (Schedule."Flight ID" = Flight."Flight ID")  
  6.    INNER JOIN "aircraft.dbf" Aircraft
  7.    ON  (Schedule."Aircraft ID" = Aircraft."Aircraft ID")