Merging two tables into one report

I know this thread is old, could you elaborate on your solution?

I have two tables that carry similar data each imported from a different source, but they both relate back to the same parents table. I'd like to create a reporting table that merges the data from the two functional tables. I set up a child table, pipeline to add or delete records to the child table whenever a parent record is added/deleted in either functional table, but that's pretty clunky. Do you have a more elegant solution?

Thanks!

Dave