UPDATE A SET FLAG=0
WHERE
EXISTS(SELECT 1 FROM B WHERE A.id = B.id AND A.flags = '1' AND B.list01 IS NOT NULL)
AND NOT EXISTS(SELECT 1 FROM C WHERE C.attID=2090 AND C.parentid=A.id)
AND FLAG=1;
WHERE
EXISTS(SELECT 1 FROM B WHERE A.id = B.id AND A.flags = '1' AND B.list01 IS NOT NULL)
AND NOT EXISTS(SELECT 1 FROM C WHERE C.attID=2090 AND C.parentid=A.id)
AND FLAG=1;
UPDATE A SET FLAGS=0
WHERE
EXISTS(SELECT 1 FROM B WHERE A.id = B.id AND B.list01 IS NOT NULL)
AND NOT EXISTS(SELECT 1 FROM C WHERE C.attID=2090 AND C.parentid=A.id)
AND FLAGS=1;