简单SQL,帮忙看看!马上结帐
DELETE FROM T_Sch A WHERE (A.ex_fg = 999)
AND (A.door_no IN (SELECT B.door_no FROM T_Door B
WHERE (B.door_key = 1)))
现在想要加删除一个条件:(A.bc_no IN (SELECT B.bc_no FROM T_Door B
WHERE (B.door_key = 1)))
该怎么加?
[解决办法]
DELETE FROM T_Sch A WHERE (A.ex_fg = 999)
AND (A.door_no IN (SELECT B.door_no FROM T_Door B
WHERE (B.door_key = 1)))
AND A.bc_no IN (SELECT B.bc_no FROM T_Door B
WHERE (B.door_key = 1))
[解决办法]
同意楼上的
