Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

problems with insert INTO

Status
Not open for further replies.

mistermci

Technical User
Joined
Sep 2, 2006
Messages
2
Location
US
I am trying to take all values/columns from one table and combine it with all values/columns from another table. I tried the this:

INSERT INTO table1(*) select * from table2

but it didn't work...can anyone help me out?

Thanks!
 
Hi

mistermci said:
but it didn't work...
Not until you give us :
[ul]
[li]the exact error message you get[/li]
[li]structure of those two tables[/li]
[/ul]
Until then, some possible errors to check :
[ul]
[li]different data type ( cast those values )[/li]
[li]different field order ( use field list instead of * )[/li]
[li]unique key violation ( filter out the possible duplicates )[/li]
[/ul]

Feherke.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top