use of 2 inner joins on 3 tables
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 pMENGE pDMBTR into (a1,aamt1)
from (( ekko as
f inner join ekbz as p on febeln = pebeln )
where p~bewtp = 'F' " DCGR
and f~bedat = itab-bedat
inner join ekpo as t on febeln = tebeln ).