ok,

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
table...)

> 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

the

> in statement.
>
> select from detail_table where id in (.......)
>
> This IN statement is not gracious I know, but this code was already made

and

> was working with Oracle and MsSQL.
>