Nested joins..Rectify the code

[Former Member]

Hi All,

I have written the following code joining view VF_KRED and table ADRC.

Now I want to join these two with ADR6 table where

link between these is: VF_KRED_{ADRNR = ADR6}ADDRNUMBER ??

How wiill the Nested join statement be written ??

Code:-

+Start-of-Selection.

select stceg stcd2 vf_kred~name1 ort01 pstlz land1 telf1 telfx brsch

sperr lifnr zterm adrnr street house_num1

into corresponding fields of table int_create_vendor

from Vf_kred left

outer join adrc on vf_kred_{adrnr = adrc}addrnumber

where bukrs IN s_bukrs OR ktokk IN s_ktokk OR lifnr IN s_lifnr.+

[andreas_mann3]

try:

select lifnr street smtp_addr ...

into corresponding fields of table int_create_vendor

from ( Vf_kred left

outer join adrc on vf_kred_{adrnr = adrc}addrnumber )

join adr6 as a6 on adrc_{addrnumber = a6}ADDRNUMBER

where bukrs IN s_bukrs OR ktokk IN s_ktokk OR lifnr IN s_lifnr.

hope that helps

God's blessing

Andreas