Re: Creat new table from multiple tables in same DB?

["paross1" <webforumsuser@xxxxxxxxxxxxxx>]

Sorry, but when I answered initially, I didn't realize that you were using 
Access, and the DDL for creating tables in Access is rather limited (from what 
I have found). Better to create the table first, then INSERT the datafrom your 
three tables into the new table by using the SELECT statements that you UNIONed 
together.

 See http://msdn.microsoft.com/en-us/library/bb177893.aspx

 Phil