Re: INSERT Syntax

Joseph,

> insert into table1(field1,field2) values (select field1, field2 from
> table
> 2);

Actually, that won't work in SQL Server either. The correct syntax (for
both databases) is:

INSERT INTO table1 ( field1, field2 )
SELECT field1, field2 FROM table2;

The "VALUES" syntax is only appropriate if you are inserting a set of
constants with no SELECT statement involved.

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco