Question reg. 'Select' statement

[Former Member]

I want to retrieve records from lqua table based on the condition that lgtyp should not be equal to 100 or 110 or 120 or 130 or 140. How should I do that in select statement?

Thanks.

[Former Member]

Hi,

write query like:

select f1 f2 f3 into corresponding fields of table tbl1

from lqua

where lgtyp not in ('100' , '110' , '120', '130', '140').

Regards

Subramanian