如何实现这个删除查询?

ysgm

如果表1和表2均有a、b、c三个字段， 要想在表1中删除两张表三个字段均相同的记录该如何编写查询？

情比金坚

原来考虑不周~~~~~~~

海狸先生

DELETE *

FROM a3

WHERE (((a & b & c) In (select (a3.a & a3.b & a3.c) as aa FROM a3 INNER JOIN 表 ON (a3.a=表.a) AND (表.b=a3.b) AND (a3.c=表.c))));

情比金坚

DELETE 表1.a, 表1.b, 表1.c FROM 表1 WHERE (((表1.a) In (SELECT [a] FROM 表2)) AND ((表1.b) In (SELECT FROM 表2)) AND ((表1.c) In (SELECT [c] FROM 表2)));

[此贴子已经被作者于2005-7-15 18:41:29编辑过]