the from clause in oracle sql can take a sql statement itself haveing
a where clause i.e.
select ..... from ( selct ... from ... where .. ) , etc
this could solve