FROM節��択��必���。��節�より������文��る他節�����利用�能�列��る表を�照���。
FROM 表� [ , 表� ] *
SELECT Cities.city_id FROM Cities WHERE city_id < 5 -- 他種ã?®è¡¨å¼? SELECT TABLENAME, ISINDEX FROM SYS.SYSTABLES T, SYS.SYSCONGLOMERATES C WHERE T.TABLEID = C.TABLEID ORDER BY TABLENAME, ISINDEX -- çµ?å?ˆé †ã‚’指定ã?™ã‚‹ SELECT * FROM Flights, FlightAvailability WHERE FlightAvailability.flight_id = Flights.flight_id AND FlightAvailability.segment_number = Flights.segment_number AND Flights.flight_id < 'AA1115' -- 表å¼?ã?¯çµ?å?ˆå¼?ã?¨ã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚ --ã?—ã?Ÿã?Œã?£ã?¦ã€?FROMå?¥ã?«ã?¯è¤‡æ•°ã?®çµ?å?ˆå¼?ã‚’ç½®ã??事ã?Œã?§ã??ã?¾ã?™ã€‚ SELECT COUNTRIES.COUNTRY, CITIES.CITY_NAME, FLIGHTS.DEST_AIRPORT FROM COUNTRIES LEFT OUTER JOIN CITIES ON COUNTRIES.COUNTRY_ISO_CODE = CITIES.COUNTRY_ISO_CODE LEFT OUTER JOIN FLIGHTS ON Cities.AIRPORT = FLIGHTS.DEST_AIRPORT