yes, syntax is bit diff.
INSERT into table1(column list) select a, b, c, d from table2 where
);
Enjoy
Nitin
- Original Message -
From: "Lay Hoon Tan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 04, 2003 11:36 AM
Subject: Inserting values
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 );
Regards
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
