I have a table ServiceRequest, which has a column 'rowid'. There is another table named 'Activity', it has a column 'srid'. These two tables have a primary and foreign key relationship on the above said coulmns 'rowid' and 'srid'. Each 'rowid' in 'ServiceRequest' table have a no of corresponding 'activity' records in the 'activity' table. this activity table have a column 'created'. I am trying to pull all the records which have the min(created)in activity table for corresponding 'rowid'of the table ServiceRequest. Please help me. Sunder.