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));
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));