Subject Re: [ib-support] IN limitation to 1500 ?
Author Roberto de Amorim

you may do like Paul Schmidt told before... using a JOIN

SELECT fields FROM table1
INNER JOIN table2 on table1.value = table2.value

it will be fastest than IN ...

(when you use a JOIN, you are NOT obligated to select some fields from other

> The user make a select and can also put a filter on the result dataset,
> then I have to select all records of a detail table it's here that come
> in statement.
> select from detail_table where id in (.......)
> This IN statement is not gracious I know, but this code was already made
> was working with Oracle and MsSQL.