Hi

For example

Code:
DELETE
FROM OM_CONTRACT_TECHNICAL_SERV t
WHERE EXISTS
(SELECT 1 
FROM OM_CONTRACT_INST c, OM_CONTRACT_SERV s, LISTA_ORDENES l  
WHERE t.service_id=s.service_id 
AND s.contract_id=c.contract_id 
AND c.order_id=l.order_id)
/
COMMIT
/
DELETE
FROM OM_CONTRACT_TECHNICAL_SERV t
WHERE EXISTS
(SELECT 1 
 FROM OM_CONTRACT_INST c,OM_CONTRACT_SERV s 
 WHERE t.service_id=s.service_id 
 AND s.contract_id=c.contract_id 
 AND c.order_id IS NULL)
/
COMMIT
/
First delete, deletes 12 rows and second 22 rows and table has 50 rows so after running these deletes I will have 16 rows left.

What I need to code is, a SQL which gives me the 16 rows left. Exactly the other way what deletes do!

Cheers