节约性能的一个sql

SELECT carrid connid

INTO (xcarrid, xconnid)

FROM sflight AS f

WHERE NOT EXISTS ( SELECT * FROM spfli

                    WHERE carrid = f~carrid

                      AND connid = f~connid ).

忘记哪里看到的，或许以后会用到