Inner Join issue

Hi everybody,

Can we inner join 4 tables at a time.

i have used the following code,

select a_{matnr a}mtart b_{werks b}lgort c_{abcin d}iblnr

into table rep_data from

mara as a inner join

mard as b on a_{matnr = b}matnr inner join

marc as c on c_{matnr = a}matnr inner join

iseg as d on d_{matnr = a}matnr

where a~matnr in s_matnr

and a~mtart in s_mtart

and b~werks in s_werks

and b~lgort in s_lgort

and c~abcin in s_abcin.

Is It correct, or changes to be done or

iS there any code to do this.

Thanks,

Rajesh.