So I have multiple tables that I want to combine into one. They all have at least one thing in common but otherwise have different # of columns and different rows.
I would like to have a query that combines all the tables into one and doesn't duplicate data as it is now. I have been reading abut union queries and is that the best solution?
Here is an example of what I am wanting
Table A
x x z 1 j 654 2 r 789
Table B
x y 1a 2$ &^ 1 r 546 767 771 2 j 999 789 772 3 c 778 779 773
Table C
x y % 1 r test
Combined- what I want
x y z 1a % 1 r 654 564 test 2 j 789 999 0 3 c 0 778 0
thanks in advance