I want to retrieve all PERNO's from a table in which appears twice in the table:
select perno from table
where section = 'SOP.DEL' and level = 'Y'
but I also want it only if there is also a row like this:
where section = 'SOP.EDIT' and level = 'Y'
Your help is appreciated. Thank you.