Quote Originally Posted by GaryMazzone View Post
That was not specified. If it is to an existing table it would be:

Insert INTO tableName Select * From tableName1
I was asking the OP...I know you knew that