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@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco