Usa el for all entries...aqui va un ejemplo
SELECT carrid connid
cityfrom cityto
deptime arrtime
airpfrom airpto
distance distid
FROM spfli
INTO CORRESPONDING FIELDS OF TABLE i_spfli
WHERE carrid IN scarrid.
SELECT carrid carrname
FROM scarr
INTO CORRESPONDING FIELDS OF TABLE i_scarr
FOR ALL ENTRIES IN i_spfli
WHERE carrid EQ i_spfli-carrid.
|