一个数据库同步的问题,高手指点一下
下面是我查询对应两个关系表,我想把air_city表中多余的字段删掉,我怎么进行判断呢。
多余的字段是指:表airplane中的没有的城市记录,但是air_city中有,我想把这些多余的记录删掉,请教怎么来判断这个过程呢··
SELECT air_city.froms, air_city.fromto, air_city.company, air_city.class
FROM Airplane INNER JOIN
air_city ON Airplane.froms = air_city.froms AND Airplane.fromto = air_city.fromto AND
Airplane.company = air_city.company AND Airplane.class = air_city.class