from rebanho a, rebanho p, rebanho m

where a.paiID=p.ID and p.qtdPremios >=2

and a.MaeID=m.ID and m.qtdPremios >=2

and a.dataAbate is Null;

from rebanho a

inner join rebanho p on a.ID=p.paiID and p.qtdPremios >=2

inner join rebanho m on a.ID=m.MaeID and m.qtdPremios >=2

where a.dataAbate is Null;

from rebanho a, rebanho p, rebanho m

where a.paiID=p.paiID

and a.MaeID=m.MaeID

and (p.qtdPremios >=2 or m.qtdPremios >=2)

from rebanho a

where a.dataAbate is Null

and ( exists (select 1 from rebanho p where p.ID = a.paiID and p.qtdPremios >=2)

or exists (select 1 from rebanho m where m.ID = a.maeID and p.qtdPremios >=2) );