Subject RE: [firebird-support] 'IN' limit still applies?
Author Alan McDonald
> Hi
>
> > UPDATE yy SET XX = 2
> > WHERE id IN(
> > SELECT zz.id from zza)
> >
>
> > I've stopped using this syntax completely.
>
>
> So what would be an equivalent?
>
> Regards,
> Steffen

EXISTS - but I have to admit that sometimes it takes a mental leap to
convert my logic = especially with NOT IN conversions.
Alan