in Addition to above
have a look at the concept of data joins
your description from above sounds also like:
- full join on some join columns
- then post process the join result
in Addition to above
have a look at the concept of data joins
your description from above sounds also like: