Hello all,

I need to update a field on a table but I cannot see any way to get
around the limitation of not being able to update a table and select
from the same table in a subquery. The MySQL docs state that
"Currently, you cannot update a table and select from the same table in
a subquery."

Here is my best attempt at the query I need:

UPDATE satisfaction SET disposition = 'new'
where pk_incident_id =
(select count(*) as incident_count, min(pk_incident_id)
from satisfaction
where last_attempt > '2006/10/01'
and disposition != 'new'
group by user)
and incident_count > 1;

Can anyone tell me how to get this to work?

Thanks,
Derek Basch