Hi Mat,

>
> update correspondence
> set arc = 1 where id in (select correspondence_id from

correspondencelog

> where arc = 1);

try this:

update correspondence
set arc = 1
where exists (select 1 from correspondencelog where
correspondence_id=correspondence.id and arc = 1);

Regards.

Ali