Jump to content

Create Multiple Tables Into One

Guest Goku

Recommended Posts

Hi All, I have 4 Identical tables that I wish to create into one table. Ive tried the following statement:

Select *into HistoricalRecords.tblRecordsfrom dbo.EngCat328,dbo.EngCAT9,dbo.MinCAT328,dbo.MinCAT9

but I end up with this error msg:Msg 2705, Level 16, State 3, Line 1Column names in each table must be unique. Column name 'ID' in table 'tblRecords' is specified more than once.Someone please help me with the correct statement.Thanx.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...