Forum Discussion
Merge Queries for multiple tables
Hello
I want to create one merged table from various tables.
I want to use Col1 from Table1 as the basis and then left outer join Col2 from Table2.
In the created MergedTable1, I want to use Col3 (which originally belonged to Table2) as the basis and join Col4 from Table3.
Unfortunately when I create the first merge with Merge Queries, I cannot select a column from Table2 (Col3) to use as the basis of the merge with Table3.
Is there any fix for this? Thanks
After your first merge, did you expand the added table and Col3 to do your second merge?
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
2 Replies
After your first merge, did you expand the added table and Col3 to do your second merge?
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
You must perform the two combinations in separate steps:
- Combine Table 1 and Table 2
- Expand Table 2
- You combine Table 2 and Table 3
- Expand Table 3
