Report - INNER JOIN Problem

Hi,

In my report List of Block Customer's, INNER JOIN is not working..

Code:----

**************************************************************

SELECT DISTINCT M1_{KUNNR M1}KTOKD M1_{NAME1 M1}CASSD M1_{AUFSD M1}LIFSD M1~FAKSD INTO CORRESPONDING FIELDS OF TABLE ITAB

FROM KNA1 AS M1 INNER JOIN KNVV AS M2 ON M1_{KUNNR = M2}KUNNR

WHERE M1~KTOKD IN ('0001' , 'KTOKD')

AND M1~CASSD EQ 'X'

OR M1~AUFSD NE ''

OR M1~LIFSD NE ''

OR M1~FAKSD NE ''

OR (M2~AUFSD NE ''

OR M2~LIFSD NE ''

OR M2~FAKSD NE ''

OR M2~CASSD EQ 'X'.

**************************************************************

Here, condition on 0001 is not matching..

Plz tell me, what is the problem in it..

Thanks

Edited by: Prince Kumar on Oct 20, 2008 9:37 AM