Inserting records from another table 1

[pingLeeQuan]

Hello, i am using the following SQL to insert records into Summary table from another table but i keep getting a syntax error. When i run teh sqls individually, they work ok... any thought on how i can get this done?

INSERT INTO tSummary
(ssnumber,unitid,projectid,tenant_lname,tenant_fname)
VALUES(select ssnumber,unitid,projectid,tenant_lname, tenant_fname from tExternalData)

The error that i get follows:

[admin] ERROR 1064: You have an error in your SQL syntax near 'select ssnumber,unitid,projectid,tenant_lname, tenant_fname from tExternalData)' at line 3

thanks in advance

 

[sleipnir214]

That's because MySQL doesn't support the kind of subquery like you're trying to use until version 4.1.

MySQL has a special syntax for selecting data from one table and inserting it into another table, the INSERT...SELECT query

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[pingLeeQuan]

dude... that worked like a charm... thanks a bunch..