topic SELECT Clause WHERE variable not in value list in Application Development and Automation Discussions

SELECT Clause WHERE variable not in value list

Former Member — Mon, 31 Mar 2008 13:38:53 GMT

Hello Masters,

I've got a question: In SQL language we can do a query like:


 SELECT my_variables FROM my_table WHERE my_variable NOT IN ('1','2','3')

I think that we can create a local table (lt_test), insert all the values ('1','2','3') inside this table and then create a query like:


SELECT my_variables FROM my_table INTO my_LocalTable where my_variable NOT IN lt_test

My question is this: Is there a way to put the list of values directly in the SELECT clause and not inside a local table?

Something like:


SELECT my_variables FROM my_table INTO my_LocalTable where my_variable NOT IN ('1','2','3')

Thank you for your time,

Jorge

Former Member — Mon, 31 Mar 2008 13:41:57 GMT

You can create ranges and use that in select clause.

Former Member — Mon, 31 Mar 2008 13:59:41 GMT

You can use the query exactly as your example, it will work.

You can also use ar ange, which is a kind of internal table, but if you prefer to put the values direct in your query, it's OK.