"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