Nested joins..Rectify the code

Former Member — Fri, 11 Jul 2008 05:42:15 GMT

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.+

Re: Nested joins..Rectify the code

andreas_mann3 — Fri, 11 Jul 2008 10:27:26 GMT

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