Help needed on SQL query...

Hi,

I have the following SQL statement...I want to know how do I join table 1 to table 2 and table 1 to table 3 when

mseg is table 1

mkpf is table 2

zmigo_extend is table 3

The below statment is syntactically wrong..Please give me the correct way to right the INNER join between 3 tables...

SELECT a_{matnr a}werks a_{gpla a}wart

a_{menge a}dmbtr b_{budat c}txjcd INTO TABLE

migo_data

FROM mseg AS a INNER JOIN mkpf AS b ON a_{mblnr = b}mblnr zmigo_extend AS c INNER JOIN ON a_{mblnr = c}mblnr

WHERE a~matnr IN so_matnr

AND b~budat IN so_budat

AND a~werks IN so_werks

AND a~lgpla IN so_lgpla

AND a~bwart IN so_bwart

AND c~txjcd IN so_txjcd.