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 [EMAIL PROTECTED] and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html