这种查询太大了,应该改一下,用不着嵌套吧。select a.…… from table1 as a,table2 b where b.field1<>a.field1 or b.field2<>a.field2 or b.field3<>a.field3 or b.field4<>a.field4
你用什么数据库?用主表连接 select a…… FROM table1 a LEFT INNER JOIN table2 b ON (a.关键字段 = b.关键字段) where b.field1<>a.field1 or b.field2<>a.field2 or b.field3<>a.field3 or b.field4<>a.field4
select a…… FROM table1 a LEFT INNER JOIN table2 b ON (a.连接字段 = b.连接字段) where b.field1<>a.field1 or b.field2<>a.field2 or b.field3<>a.field3 or b.field4<>a.field4
select a…… FROM table1 a LEFT JOIN table2 b ON (a.连接字段 = b.连接字段) where b.field1<>a.field1 or b.field2<>a.field2 or b.field3<>a.field3 or b.field4<>a.field4
from table1 as a,table2 b
where b.field1<>a.field1 or b.field2<>a.field2 or b.field3<>a.field3 or b.field4<>a.field4
select a……
FROM table1 a LEFT INNER JOIN table2 b
ON (a.关键字段 = b.关键字段)
where b.field1<>a.field1 or b.field2<>a.field2 or b.field3<>a.field3 or b.field4<>a.field4
FROM table1 a LEFT INNER JOIN table2 b
ON (a.连接字段 = b.连接字段)
where b.field1<>a.field1 or b.field2<>a.field2 or b.field3<>a.field3 or b.field4<>a.field4
FROM table1 a LEFT JOIN table2 b
ON (a.连接字段 = b.连接字段)
where b.field1<>a.field1 or b.field2<>a.field2 or b.field3<>a.field3 or b.field4<>a.field4