delete table1 通过子查询

delete from table1
 where no3 in
       (select uuid
          from table2
         where (no1,decode(no2,'','C',no2)) in
               (select a.no1,decode(a.no2,'','A',a.no2)
                  from table3 a));