inner join for 4 tables

Hi forum,

Pls correct the following code..

SELECT a~zbukr

a~hbkid

a~hktid

a~checf

a~waers

a~rwbtr

a~bancd

a~vblnr

a~pernr

a~voidr

a~rzawe

a~laufd

a~empfg

a~gjahr

a~zaldt

a~znme1

a~rec_belnr

b~bankl

c~bankn

d~duedt

INTO CORRESPONDING FIELDS OF TABLE it

FROM payr AS a

INNER JOIN t012 AS b

ON a_{hbkid = b}hbkid

inner join t012k as c

on b_{hbkid = c}hbkid

• and on a_{hbkid = c}hbkid

inner join t51r5 as d

on c_{bukrs = d}bukrs

• and on a_{waers = d}waers

WHERE a~zaldt IN s_zaldt

AND a~vblnr IN s_vblnr

AND a~znme1 IN s_znme1

AND a~rec_belnr IN s_rec

AND a~waers IN s_waers.