> UPDATE icm_priv, icm_groups > SET icm_priv.priv=5 > WHERE icm_priv.gid IN ( > SELECT icm_priv.gid > FROM icm_priv, icm_groups > WHERE icm_priv.gid=icm_groups.gid > AND icm_priv.uid=icm_groups.owner); Oooops, more sloppy replying from me leads to misinformation! should be 'UPDATE icm_priv' only. -s