Skip to Content
0
Former Member
Jul 07, 2009 at 06:45 PM

Select-statement with IN

30 Views

Hi everybody,

I have a number (several thousands) of single values. This values must be inserted into the table lt_singelvalues. Now i want to use a SELECT statement with "IN" like the following example in order to get only values within lt_singlevalues:


  SELECT * from mytable INTO lt_mytable 
     WHERE value IN lt_singlevalues

How can i create a table like lt_singlevalues in order to use "WHERE value IN lt_singlevalues"?

regards,

sid

Edited by: Sid on Jul 7, 2009 8:46 PM