在ID不知道的情况下怎么删,而且两张表还是有 很多相同的地方。比如上面的,不止id=3的相同,还有4 5 6……
追答(select ID as 表aID from A) as 表一
right union (select ID as 表bID from B) as 表二;
以上结果组成一个大表;
删除iD=3的记录:
delete from
(
(select ID as 表aID from A) as 表一
right union (select ID as 表bID from B) as 表二;
)
where
表aID=3 and 表bID;