problem with logical or

[Former Member]

hi friends i am using OR in a select statement like this :

select single KAWRT from KONV into var2 where KNUMV = var1 and STUNR = 65 or STUNR = 60 .

but what i want is that the result for this should be calculated as

KNUMV =var1 and (STUNR = 65 or STUNR =60)

means result of STUNR = 65 or STUNR =60 should be AND with KNUMV =var1

when i tried like following :

select single KAWRT from KONV into var2 where KNUMV = var1 and STUNR =( 65 , 60)

it is giving error.is there something wrong.

[amit_khare]

Replace '=' with 'IN'..

[former_member206377]

Hi Achal,

Have you tried this ?

      SELECT  SINGLE kawrt
             FROM konv
             INTO var2
             WHERE knumv = var1 AND
                    (  stunr = '65' OR stunr = '60' ) .

[Former Member]

Hello

Try this:

select single KAWRT from KONV into var2 where 
KNUMV = var1 and ( STUNR = '65' OR STUNR =  '60' ).

[Former Member]

Hi Anchal,

select single KAWRT from KONV into var2 where KNUMV = var1 and ( STUNR = 65 or STUNR = 60 )

.

Manas M.

[Former Member]

hi,

use IN operator instead of EQ.