[SQL] INSERT ... SELECT problem in Mysql

the situation could easily be very confusing!) Is that correct? PostgreSQL allows this which is very handy, but breaks so some ANSI compliance. Can anyform that ANSI SQL doesn´t allow this? Thanx Christoph Nelles -- Mit freundlichen Grüssen Evil Azrael mai

Re: [SQL] INSERT ... SELECT problem in Mysql

Nelles Am Freitag, 4. Juli 2003 um 23:45 schrieben Sie: TL> Evil Azrael <[EMAIL PROTECTED]> writes: >> I have a problem with this part in the text >> >> The target table of the INSERT statement cannot appear in the FROM >> clause of the SELECT part of th