I have this going already -
SELECT Item_Name, ID, Item_No From accessories
UNION select Item_Name, ID, Item_No From bars;
which does indeed use UNION to merge tables. BUT i must be able to merge columns from tables to one big column, so perhaps i was not toally clear in the first questions. I know it doesnt make any sense really why i should bother doing that - for the only reason is that i have a website and runs a search script in which i must be able to merge all these tables, and then merge 2 coulns in each table as well (that would be a products Name and ID).
Sorry its a tricky thing to do, so ive managed to combind tables - but now i need to be able to merge colmns in each table into one big massive one. There are 22 tables in the main database. Is it feasible do u think?