use of 2 inner joins on 3 tables

[Former Member]

I want to use 2 inner joins on 3 tables i.e. ekko,ekpo,ekbz.follwing is code where there is an error;how to proceed:-

select p_{MENGE p}DMBTR into (a1,aamt1)

from (( ekko as

f inner join ekbz as p on f_{ebeln = p}ebeln )

where p~bewtp = 'F' " DCGR

and f~bedat = itab-bedat

inner join ekpo as t on f_{ebeln = t}ebeln ).

[ThomasZloch]

move the WHERE-conditions after the last JOIN.

Thomas

[Former Member]

Hi There,

NO matter Howmany Joins You using WHERE conditions after all the joins...

re