sqlcode -802

[gdg1976]

hi all,


i get sqlcode -802 from this UPDATE:

[pre]UPDATE taba SET afield1 = 'S'
WHERE afield2 = 'I'
AND afield3 IN
(SELECT bfield3 FROM tabb
WHERE bfield1 IN
( SELECT cfield1 FROM tabc
WHERE cfield1 = 'I'
GROUP BY cfield1 HAVING count(*) > 1)
GROUP BY bfield3)[/pre]

Perhaps the reason could be that the follow subselect has no record ?
[pre](SELECT cfield1 FROM tabc
WHERE cfield1 = 'I'
GROUP BY cfiel1 HAVING count(*) > 1 )[/pre]

but why don't i get 100 ?

thanks
Bye