新人SQL求助有表A,B 先查询到select a,b from A; 要删除表B中B.a=a and B.b=b的[解决办法]试试这个: delete B where exists(select a,b from A where B.a = A.a and B.b = A.b)