How to merge some columns in different tables ?

All forum topics
Previous Topic
Next Topic

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.