Hi,
I am trying to insert data from one table to another with the command:
INSERT INTO attrib_values (attrib_id,attrib_value) values (Select
attrib_id,attrib_default_value FROM attribs)
And I get error massage:
You have an error in your SQL syntax near 'Select
attrib_id,attrib_default_value FROM attribs)' at line 1
Why do I get this error and how can I insert the data from one table to the
other?
Best Regards,
Ilan
_________________________________________
ILAN FAIT
Tel: 972-9-9519133 Ex.247 iWeb Technologies
Fax: 972-9-9519134 91 Medinat Ha'Yehudim St.
Herzliya 46120 IL
mailto:[EMAIL PROTECTED] www.iweb.com
