How to merge some columns in different tables ?

[zzzzoooo]

Hi,

Could you please tell me how to combine some columns in different tables together. For example, table X has columns A, B and C; table Y has column A, B and D; table Z has column A, B and E; and I'd like to take columns A and B from tables X, Y and Z. It seems that I can't use "Append Queries", nor "Merger Queries".

Thank you.

[WanderingBI]

Hi! 

Appending the queries should work. Lets say you have the following example tables:

Table X:

Table Y

Table Z

Create a reference to TableX (or any other table):

Then append queries like so:

You will then get the following output:

Please let me know if it worked for you.