Well, I skiped this manual part :-) Maybe the simple select and insert is the simplest form.
-- Julio Nobrega Don't eat the yellow snow. "Jim" <[EMAIL PROTECTED]> wrote in message news:p05101010b8318afec141@[192.168.1.17]... > > It appears that this is forbidden ... > > From mysql.com: > > The target table of the INSERT statement cannot appear in the FROM > clause of the SELECT part of the query because it's forbidden in ANSI > SQL to SELECT from the same table into which you are inserting. (The > problem is that the SELECT possibly would find records that were > inserted earlier during the same run. When using sub-select clauses, > the situation could easily be very confusing!) > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]