Skip to Content
0
Former Member
Jul 28, 2008 at 07:34 AM

in where condition OR operator not working (i am using inner joins)

25 Views

in where condition OR operator not working (i am using inner joins)

SELECT l~lifnr

l1~name1

b~waers

b~dmbtr

b~zfbdt

b~zbd1t

b~zbd2t

b~zbd3t

b~belnr

b~xblnr

b~shkzg

b~blart

INTO CORRESPONDING FIELDS OF TABLE int_bsik

FROM lfb1 AS l INNER JOIN lfa1 AS l1

ON llifnr = l1lifnr

INNER JOIN bsik AS b

ON llifnr = blifnr AND

lbukrs = bbukrs

WHERE

bzfbdt LE p_allgst AND lbukrs = p_bukrs AND

( llifnr IN s_lifnr OR l1KTOKK = S_KTOKK OR b~PRCTR in S_PRCTR ).

pls do check this..

thank's in advance