I have two tables with Identical Fields in each.
The first table has old data from 2008 and the second table has data from 2009
All I wish to do is append the data together and returning one table of data.
Simply there are 2 Fields in each Table ( Product and Reference )
So I want to add the Products and References from the 2008 table to the 2009 table. Returning a combined data set.
I assume this is easy, but I don't write SQL very often.