Re: Update same table from subquery not allowed

2005-02-16 Thread Michael Stassen
matt_lists wrote: matt_lists wrote: "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 its

Re: Update same table from subquery not allowed

2005-02-16 Thread matt_lists
matt_lists wrote: "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

Update same table from subquery not allowed

2005-02-16 Thread 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