I am very unfamiliar with union queries... I have 5 tables that I would like to show the results of on one query. They all share one common column that is "DateSpec" there are only 4 different values that that could be. The ending table would be a 4 rowed table of the 4 datespec values. Then the columns would be all the different columns of the 5 tables.
DateSpec Column1 Column2
Value1 ValuefromTable1 ValuefromTable2
Value2 ValuefromTable1 ValuefromTable2
Vlaue3 ValuefromTable1 ValuefromTable2
Vlaue4 ValuefromTable1 ValuefromTable2
There would be about 15 tables in the end. Any idea? I think it is simple... I just am very unfamiliar with union queries. THanks!