Huh, thanks Dmitry. I have switched the code to use
record_id=ANY(Select...). Which one would be faster in my case, IN or
(ANY)?

--- In firebird-support@yahoogroups.com, "Dmitry Yemanov" <dimitr@...>
wrote:

>
> "nikicab_1999" <nikicab_1999@...> wrote:
> >
> > SELECT DISTINCT User_id FROM Setting_Vals
> > WHERE User_id IN(SELECT User_id from Setting_Vals WHERE (Setting_id =
> > 125 and Setting_Value BETWEEN 280 and 295))
> > AND User_id IN(SELECT User_id WhERE (Setting_id = 159 and
> > Setting_Value BETWEEN 0.5 and 3.8))
> >
> > and it works but the problem is limitation of the IN (1499)
>
> The limitation relates to IN (<value list>) only. IN (<subselect>)

has no

> limits.
>
>
> Dmitry
>