topic Re: inner join in Application Development and Automation Discussions

inner join

Former Member — Tue, 29 Aug 2006 09:12:13 GMT

hi experts,

could u plz give me the code for writing inner join on three tables.

regards,

siri.

Re: inner join

Former Member — Tue, 29 Aug 2006 09:14:53 GMT

Here is the sample

select a_{f1 b}f2 c~f3

into table itab

from table1 as a inner join table2 as b on a_{f1 = b}f1

inner join table3 as c on a_{f1 = c}f1

where a~f1 = parameter.

Regards

Anurag

Re: inner join

Former Member — Tue, 29 Aug 2006 09:23:42 GMT

Hi,

Copy paste this code in SE38. Give where condition.

DATA : BEGIN OF ITAB OCCURS 0,

MATNR LIKE MARA-MATNR,

ERSDA LIKE MARA-ERSDA,

MAKTX LIKE MAKT-MAKTX,

WERKS LIKE MARC-WERKS,

END OF ITAB.

select A_{MATNR A}ERSDA B_{MAKTX C}WERKS INTO TABLE ITAB FROM MARA AS A INNER JOIN MAKT AS B ON A_{MATNR = B}MATNR INNER JOIN MARC AS C ON A_{MATNR = C}MATNR

WHERE A~MATNR = <PARAMETER>.

Reward points if useful.

Regards,

Senthil

Re: inner join

Former Member — Tue, 29 Aug 2006 09:25:46 GMT

pls find the following sample code

select tab1_{field into corresponding fields of table itab from tab1 inner join tab2 on tab1}field1 = tab2_{field2 inner join tab3 on tab1}field1 = tab3~field1.

Thanks & Regards

Re: inner join

Former Member — Tue, 29 Aug 2006 09:26:42 GMT

MY PROB SOLVED

THANKX aNURAG

SIRI

Re: inner join

Former Member — Tue, 29 Aug 2006 09:27:10 GMT

select tab1~fld1

tab2~fld2

tab3~fld3

tab3~fld4

into table itab

from tab1 inner join tab2 on tab1_{fld1 = tab2}fld1

inner join tab3 on tab1_{fld1 = tab3}fld1

where tab1~fld in p_fld1.

hope this helps,

do reward if it helps,

priya.

Re: inner join

Former Member — Tue, 29 Aug 2006 09:28:59 GMT

U r welcome..Sireesha.

Please mark the question as resolved with a blue star...!!

Cheers !!