Skip to Content
0
Former Member
Dec 27, 2007 at 04:34 AM

inner join for 4 tables

21 Views

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 ahbkid = bhbkid

inner join t012k as c

on bhbkid = chbkid

  • and on ahbkid = chbkid

inner join t51r5 as d

on cbukrs = dbukrs

  • and on awaers = dwaers

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.