yes, syntax is bit diff. INSERT into table1(column list) select a, b, c, d from table2 where <condition>);
Enjoy Nitin ----- Original Message ----- From: "Lay Hoon Tan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 04, 2003 11:36 AM Subject: Inserting values via a SELECT statement > Is there any way that SQL can accomplish the insertion of values through a > "select" statement, > eg, INSERT into table1 VALUES ( > select a, b, c, d > from table2 > where <condition>); > > ???? > > Regards > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]