简单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))
------解决方案--------------------
同意楼上的