删除关联错误

SELECT * FROM FJ WHERE  EXISTS (SELECT TBYBH FROM "关联错误信息" WHERE 举证图斑预编号 = FJ.TBYBH)

SELECT 改为 DELETE 即为删除

后续

 SELECT * FROM "FJ" WHERE ((FJ ISNULL and FJLX != 'S') or (JYM = ''and FJLX != 'S') or (Latitude = 0 and FJLX != 'S'))

原文地址:https://www.cnblogs.com/RedLn/p/14222853.html