topic Re: SELECT statement in Application Development and Automation Discussions

SELECT statement

Former Member — Mon, 25 Aug 2008 18:43:52 GMT

Hi All,

I need to specify 2 conditions for BTRTL in select statement like btrtl should only be equal to both '1000' and '1001'.

How can we do this in a select statement.

thanks

Former Member — Mon, 25 Aug 2008 18:45:44 GMT

u can use BTRTL NE 1000 and BTRTL NE 1001

Not BTRTL in ('1000', '1001')

Former Member — Mon, 25 Aug 2008 18:50:41 GMT

> I need to specify 2 conditions for BTRTL in select statement like btrtl should only be equal to both '1000' and '1001'.

where ( BTRTL = '1000' or

BTRTL = '1001' ).

SOME THING LIKE THIS..

SELECT * FROM SFLIGHT

INTO FLIGHT

UP TO 1 ROWS

WHERE ( CARRID = 'AS' OR CARRID = 'BB' ).

ENDSELECT.

Former Member — Mon, 25 Aug 2008 18:50:49 GMT

WHERE BTRTL in ('1000','1001')

Former Member — Mon, 25 Aug 2008 18:52:10 GMT

Hi,

Thanks for the reply.

In my case btrtl equals to 1000 and 1001.

How can we do for this?

Thanks

Former Member — Mon, 25 Aug 2008 18:55:25 GMT

WHERE BTRTL in ('1000','1001') OR Where (BTRTL EQ 1000 OR BTRTL EQ 1001)

u can use this, it acts union - pick all the values where BTRTL is equal to 1000 or BTRTL is equal to 1001.

At same time single record cannot hold both values 1000 & 1001 in BTRTL rite

Former Member — Mon, 25 Aug 2008 23:17:59 GMT

Thanks everyone,i solved it

thank you very much