You're going to have to be a lot more specific on your setup... and your reasons for wanting to do this. Do all the tables hold the same data? Due to the fact that you have different numbers of columns with different column names, I'm guessing they don't. Are you trying to consolidate your entire database into one table? (That'd be a bad idea... to put it lightly)
Try starting with 3 table definitions so we can see the kind of merge'ing you are trying to accomplish.
Seth Phelabaum
Consistency is only a virtue if you're not a screwup. 😉
Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]