Inserting values via a SELECT statement

[Lay Hoon Tan]

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]