节约性能的一个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 ). 忘记哪里看到的,或许以后会用到 http://blog.sina.com.cn/sapliumeng