Hi Barry,
see: http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
you cannot insert into a table you're doing select on
(same goes for update).
Regards,
/Johan
Barry skrev:
I get this error:
Fehler in
/home/virtual/site4/fst/var/www/html/adminheaven/artikel-vererben-save.php
in Zeile 36 mit Error:<br>
Query:INSERT INTO objektflyer_verknuepfung
(av_o_id_haupt,av_o_id_link,av_text,av_op_id) SELECT
418,av_o_id_link,av_text,av_op_id FROM objektflyer_verknuepfung WHERE
av_id IN (1)
<br>Not unique table/alias: 'objektflyer_verknuepfung'
I use a very old Mysql. 3.2 or similiar.
Anyone knows that error and can give a helping hand?
Thanks, Barry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
