topic Re: Regarding Joins in Application Development and Automation Discussions

Regarding Joins

Former Member — Thu, 05 Apr 2007 15:53:08 GMT

Hi All,

Please check this code.

select afko~aufnr

afvc~vornr

afvc~steus

afvv~arbei

afvc~anzzl

afvv~ismnw

afvv~ofmnw

crhd~arbpl

afvv~fssbd

afvv~fssbz

afvv~fseld

afvv~fselz

mhio~abnum

mhis~nplda

into corresponding fileds of table t_opr

from afvv join afvc on (afvc_{aufpl = afvv}aufpl and afvc_{aplzl = afvv}aplzl)

join crhd on afvc_{arbid = crhd}objid

join afko on afko_{aufpl = afvc}aufpl

join mhio on mhio_{aufnr = afko}aufnr

join mhis on ( mhis_{abnum = mhio}abnum and mhis_{warpl = mhio}warpl ).

Re: Regarding Joins

Former Member — Thu, 05 Apr 2007 16:01:39 GMT

hi,

Avoid using join statement use FOR ALL ENTRIES instead of joins

In the given code specify some of the related conditions in where condition too..

select afko~aufnr

afvc~vornr

afvc~steus

afvv~arbei

afvc~anzzl

afvv~ismnw

afvv~ofmnw

crhd~arbpl

afvv~fssbd

afvv~fssbz

afvv~fseld

afvv~fselz

mhio~abnum

mhis~nplda

into corresponding fileds of table t_opr

from afvv join afvc on (afvc_{aufpl = afvv}aufpl and afvc_{aplzl = afvv}aplzl)

join crhd on afvc_{arbid = crhd}objid

join afko on afko_{aufpl = afvc}aufpl

join mhio on mhio_{aufnr = afko}aufnr

join mhis on ( mhis_{abnum = mhio}abnum and mhis_{warpl = mhio}warpl )

<b>where <Conditions>.</b>

Regards,

Santosh

Re: Regarding Joins

Former Member — Thu, 05 Apr 2007 16:10:33 GMT

Dont use joins instead use for all entries as joins will raise performance issues.

Regards

Haritha.

Re: Regarding Joins

Former Member — Thu, 05 Apr 2007 16:30:58 GMT

Thanks for your replay.

i know that whenever i use for all statement instead of join.

but i cant change join statement.

is this query is correct or not......just you can find that query

Thanks in advance.

Re: Regarding Joins

Former Member — Thu, 05 Apr 2007 16:52:35 GMT

this is syntactically correct but u wont get anyvalue in the table.

Specify ur where condition to fetch the values from table.

select afko~aufnr

afvc~vornr

afvc~steus

afvv~arbei

afvc~anzzl

afvv~ismnw

afvv~ofmnw

crhd~arbpl

afvv~fssbd

afvv~fssbz

afvv~fseld

afvv~fselz

mhio~abnum

mhis~nplda

into corresponding fields of table t_opr

from afvv join afvc on afvc_{aufpl = afvv}aufpl and afvc_{aplzl = afvv}aplzl

join crhd on afvc_{arbid = crhd}objid

join afko on afko_{aufpl = afvc}aufpl

join mhio on mhio_{aufnr = afko}aufnr

join mhis on mhis_{abnum = mhio}abnum and mhis_{warpl = mhio}warpl.