Morning
I am currently trying (and failing) to merge two tables with 9 identical columns.
In the "Stock" column on both tables it gains its values through a combo box.
When I do the union query, it gives me the stock id (combo - column 1)rather than the stock name (combo - column 2)
SELECT * FROM TBeefLabel
UNION ALL
SELECT * FROM TLabelSausage;
Any help is appreciated. This is the first time I have used union queries as you can probably tell.
Ian
I am currently trying (and failing) to merge two tables with 9 identical columns.
In the "Stock" column on both tables it gains its values through a combo box.
When I do the union query, it gives me the stock id (combo - column 1)rather than the stock name (combo - column 2)
SELECT * FROM TBeefLabel
UNION ALL
SELECT * FROM TLabelSausage;
Any help is appreciated. This is the first time I have used union queries as you can probably tell.
Ian