Forum Discussion
Table Relationships
I was able to create the column in both tables.
When I try to merge them: Data->Edit Queries->Edit Queries->Merge Queries->Merge as New->Full Outer Join
It doesn't show the second table and the entry that is created appears as blank.
Do I merge or append?
Append Worked.
Hello Anonymous
you have to use the 'Append' option which corresponds to the SQL UNION ALL operator.
The 'Merge' option is the equivalent of the different types of JOIN which is not what you want to do in this case.
Hello Anonymous
within your query, you just need to append both tables together and add an additional column categorizing each table as 'Day 1' for the first table, 'Day 2' for the second table
I was able to create the column in both tables.
When I try to merge them: Data->Edit Queries->Edit Queries->Merge Queries->Merge as New->Full Outer Join
It doesn't show the second table and the entry that is created appears as blank.
Do I merge or append?
Append Worked.
Hello Anonymous
you have to use the 'Append' option which corresponds to the SQL UNION ALL operator.
The 'Merge' option is the equivalent of the different types of JOIN which is not what you want to do in this case.