>
> am I right in thinking that if the select returns more that 1500
> values the statement will fail in some way
> I remember that this used to be an issue and I can't find any
> reference to it being removed
>
>
> UPDATE yy SET XX = 2
> WHERE id IN(
> SELECT zz.id from zza)
>

also, if you mean by failure that the select or update will be very slow (to
the point of useless) then you are right. Unless the list is quite short or
the subselect is small.
I've stopped using this syntax completely.
Alan