This is probably a common scenario and I have tried to search for answer, but probably using wrong terminology.
I have parent and child tables where child have foreign key pointing to parent's primary key.
But how can I show all child records based on a filter on the parent?
Guess there are at least two ways to do this and I would like to see both
1. I already have a collection of the parent items filtered the way I'd like. How can I create a collection of the child records, filtered by the ones in the parent collection?
2. How can I create this in one query (collection) in case I don't need the parent collection and avoid overhead?
Thanks!
