Skip to Content
0
Former Member
Sep 19, 2008 at 01:48 PM

use of 2 inner joins on 3 tables

19 Views

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 ).