I'm trying to find the best way to write this query, which involves a Parent-Child relationship. Any suggestions would be greatly appreciated.
I want to return the Parent records that have Child records that have not been completed in over 120 days.
Details...
- Parent.ID = Child.ParentID
- Need to query for the last completed Child record (Child.Status = 'Completed') belonging to each Parent record and use the Child.StatusDate to see if it's over 120 days old.
I know this is about as clear as mud, so please let me know if I can provide more details.
TIA...
I want to return the Parent records that have Child records that have not been completed in over 120 days.
Details...
- Parent.ID = Child.ParentID
- Need to query for the last completed Child record (Child.Status = 'Completed') belonging to each Parent record and use the Child.StatusDate to see if it's over 120 days old.
I know this is about as clear as mud, so please let me know if I can provide more details.
TIA...