UPDATE yy y SET y.XX = 2
WHERE EXISTS(SELECT * FROM zza z where z.id = y.id)

is the alternative I normally use.

HTH,
Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Steffen Heil
Sent: 17. desember 2009 15:35
To: firebird-support@yahoogroups.com
Subject: AW: [firebird-support] 'IN' limit still applies?

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