Hello
> INSERT INTO new_table (campo1,campo2) SELECT (campo1,campo2) FROM old_table
^ ^
The 2nd set of parentheses should not be there.
> Mysql dont suport sub-querys yet, we will be waiting
It is not a subquery issue, see the section 7.21 of the manual.
cheers
--
TS
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
