Skip to Content
0
Former Member
May 10, 2013 at 04:16 PM

How can I use the WHERE clause along with 'IN' and 'select-option'?

35 Views

Hello,

I am having trouble using the WHERE clause with 'IN' and 'select-option'.
I have a select-option with intervals, but when I executed the program it says that the operator is followed neither by an internal table nor by a value list.

Here's what I have:

SELECT-OPTIONS f_number FOR SFLIGHT-CONNID.

SELECT * INTO i_tab FROM SFLIGHT

WHERE CONNID IN f_number.

Thank you in advance.