FROM 節

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