topic Re: Inner Join Select query in Application Development and Automation Discussions

Inner Join Select query

Former Member — Mon, 20 Oct 2008 04:32:55 GMT

hello all,

Below is a inner join query

SELECT a_{ebeln a}ebelp a_{packno b}zekkn b~ps_psp_pnr

FROM ( ( ekpo AS a INNER JOIN ekkn AS b

ON a_{ebeln = b}ebeln

AND a_{ebelp = b}ebelp )

INNER JOIN prps AS c

ON b_{ps_psp_pnr = c}pspnr )

INTO TABLE t_wbspo

WHERE a~ebeln IN s_ebeln

AND c~psphi IN s_psphi

AND stufe = c_task.

I want to modify this select and put one more join on ekkn-aufnr

and aufk-afunr .

Now for this i write the below code

SELECT a_{ebeln a}ebelp a_{packno b}zekkn b_{ps_psp_pnr b}aufnr

FROM ( ( ( ekpo AS a INNER JOIN ekkn AS b

ON a_{ebeln = b}ebeln

AND a_{ebelp = b}ebelp )

INNER JOIN prps AS c

ON b_{ps_psp_pnr = c}pspnr )

INNER JOIN aufk AS d

ON b_{aufnr = d}aufnr )

INTO TABLE t_wbspo

WHERE a~ebeln IN s_ebeln

AND c~psphi IN s_psphi

AND d~aufnr IN s_aufnr

AND stufe = c_task.

By the above way does it puts a join on ekkn-aufnr and aufk-aufnr ?

Is the above way the right way to do it ?

Please confirm

regards

Re: Inner Join Select query

Former Member — Mon, 20 Oct 2008 04:41:14 GMT

Hey,

You can try your code it is the right way to join the table and it does join on ekkn-aufnr and aufk-aufnr

Regards,

Midhun Abraham

Re: Inner Join Select query

Former Member — Wed, 07 Jan 2009 00:33:41 GMT

Hello Bhanu,

Do you face any performance issue? Query looks good now, further you can refer to following threads to know more on JOIN-

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ec77446011d189700000e8322d00/frameset.htm

Thank You,

Nishikant Kumbhar.

Re: Inner Join Select query

Former Member — Wed, 07 Jan 2009 00:37:54 GMT

Hello Bhanu,

After your code changes you can check for SQL trace to know which one is giving better result.

Thank You,

Nishikant Kumbhar.