2005-12-05 Oracleで複数条件でのサブクエリを使ったdelete DELETE FROM TEST1 WHERE (KYE1,KYE2) IN ( SELECT KYE1,A.KYE2 FROM TEST2 WHERE SUBKYE1 = 1)