Say you have these relationships:
A>-----B------<C. (----< means one to many)
a calculation in B like this:
list ( list ( A::Field1 ) ; list ( C::Field2) )
will produce list that you describe.
A union query using ExecuteSQL might also work.
the "and" in your post calls for intersection, not for union.
I might be wrong, though - can you confirm ?
yes I need to take some records from one table and some records from one other.