Minus Statment verbessern

[turgar]

Hier noch mal die genauere Struktur:

  
create view cleaned as  
  
  
select identifier  
from test  
where identifier like 'XY%'  
and status = 'IO'  
and action != 'X'  
and substr(identifier, 3, 12) in (select col from cesTable where region in('CHD'))  
  
minus  
  
select identifier  
from test  
where identifier like 'XY%'  
and status = 'NIO'  
and action != 'X'  
  
minus  
  
select identifier  
from test  
where identifier like 'XY%'  
and status = 'NIC'  
and action != 'X'  
  
minus  
  
select identifier  
from test  
where identifier like 'XY%'  
and status = 'NIZ'  
and action != 'X'  

Du meinst also, ich kann auf sämtliche minus-Statements verzichten?
Scheint leider nicht zu klappen;