I would probably use the merge join to pull all the records into a staging table and then do additional manipulations via creating a view, etc.