topic Re: Question reg. 'Select' statement in Application Development and Automation Discussions

Question reg. 'Select' statement

Former Member — Thu, 08 Feb 2007 00:46:22 GMT

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.

Re: Question reg. 'Select' statement

Former Member — Thu, 08 Feb 2007 00:51:43 GMT

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