Inner join problem

Hi All,

I am writing the inner join for the tables LFA1 and LFB1. like this.

SELECT a_{lifnr a}ktokk a_{name1 a}sortl a~adrnr

b_{bukrs b}zterm

INTO CORRESPONDING FIELDS OF TABLE it_lfb1

FROM lfa1 AS a

INNER JOIN lfb1 AS b

ON b_{lifnr = a}lifnr

WHERE a_{sperr = ' ' AND a}loevm = ' '

AND a_{ktokk = 'ZZ03' OR a}ktokk = 'ZZ04' OR a~ktokk = 'ZZ05'

AND b~bukrs = p_cocode.

I am using the company code 4402

When iam getting the data 3 extra records are coming which are not avaliable in the company code 4402

<<text removed>>.

Edited by: Matt on Nov 21, 2008 11:57 AM