Update same table from subquery not allowed

[matt_lists]

"One restriction is that currently you cannot modify a table and select 
from the same table in a subquery. This applies to statements such as 
|DELETE|, |INSERT|, |REPLACE|, and |UPDATE|."

Anyboyd know if this will be fixed?
Working around it with a join on itself, is there some reason updating a 
table with a subquery on itself is not alowed?

Done it many times with other db's
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]