Hi Sanjay >Now I need the output as >Fatherid and its ChildId only and only if all of >it Child are born in some TimeFrame. If any of the >Child is born out of this TimeFrame then it will=20 >ignore all of those FatherId and ChildId. To find the fathers a query like the following one should do the trick: select fatherid from a, b where a.childid =3D b.childid group by a.fatherid having min(b.dob) >=3D to_date('01-JAN-04') and max(b.dob) <=3D = to_date('31-DEC-04') HTH Chris -- //www.freelists.org/webpage/oracle-l