IN clause instead of Sub-select

[txematrix]

Hello, how can I force the use in the SQL statement of the IN CLAUSE instead of a sub-query?

I have a table (view) with the values I need, but the performance with sub-query is worst than with IN (values, ...).

I hope you understand me, and sorry for my bad english.

regards

 

[blom0344]

Simply using 'in list' instead of 'equal' in query panel conditions section will do the trick........

T. Blom
Information analyst
tbl@shimano-eu.com

 

[txematrix]

Thanks for your help, but it runs dynamically?, if the view is changing every time, the list do the same.
what I want to do is the results of a PROMPT but without choosing any value.

Thanks in advance for your help

 

[blom0344]

Sorry for misreading your question, this is of course NOT dynamical. Subquery will be slower in any case, cause the inner query will have to build the value list , probably based on a condition in the where clause.

My suggestion will of course just work with a fixed list....

T. Blom
Information analyst
tbl@shimano-eu.com

 

[sh4kil]

I think it will still work as you state that the View is actually changing so that means blom0344's recommendation should still do the trick