topic Inner join problem in Application Development and Automation Discussions

Inner join problem

naimkhans_babi — Wed, 12 Apr 2006 06:39:58 GMT

Dear firends

How are you,,,

I am facing a problem in inner join...please have a look at the code:

select a_{equnr a}tplnr a~werk

b_{equnr b}werks b~stlnr

from v_equi as a

inner join eqst as b

on a_{equnr = b}equnr

into corresponding fields of table it_eqst

where equnr in equp_no.

if sy-subrc = 0.

select stlnr stlkn idnrk posnr

from stpo

into corresponding fields of table t_stpo

for all entries in t_eqst

where stlnr = t_eqst-stlnr and

stlty = 'E'.

this code should give me equipment number as well as functional location, but i am having this message

"The column name "EQUNR" has two meanings. ABAP/4 Open SQL statement."

plese tell me where i am doing mistake, apart from inner join this query will be this way:

"select equnr from v_equi

into corresponding fields of table t_equi

where tplnr in s_tplnr and

equnr in s_equnr.

if sy-subrc = 0.

select equnr stlnr

from eqst

into corresponding fields of table t_eqst

for all entries in t_equi

where equnr = t_equi-equnr.

if sy-subrc = 0.

select stlnr stlkn idnrk posnr

from stpo

into corresponding fields of table t_stpo

for all entries in t_eqst

where stlnr = t_eqst-stlnr and

stlty = 'E'.

but it didnt produce me functional location..

please help me to solve this problem any code, suggestion , will be greate help of mine

thanking you,

regards,

naim

Re: Inner join problem

Former Member — Wed, 12 Apr 2006 06:41:48 GMT

select a_{equnr a}tplnr a~werk

b~stlnr

from v_equi as a

inner join eqst as b

on a_{equnr = b}equnr

into corresponding fields of table it_eqst

where a~equnr in equp_no.

if sy-subrc = 0.

select stlnr stlkn idnrk posnr

from stpo

into corresponding fields of table t_stpo

for all entries in t_eqst

where stlnr = t_eqst-stlnr and

stlty = 'E'.

just delete b_{equnr than it is ok .... because thee is already a}equnr

Re: Inner join problem

Former Member — Wed, 12 Apr 2006 06:43:17 GMT

hi naim,

select a_{equnr a}tplnr a~werk

b_{equnr b}werks b~stlnr

from v_equi as a

inner join eqst as b

on a_{equnr = b}equnr

into corresponding fields of table it_eqst

where a-equnr in equp_no.

if sy-subrc = 0.

select stlnr stlkn idnrk posnr

from stpo

into corresponding fields of table t_stpo

for all entries in t_eqst

where stlnr = t_eqst-stlnr and

stlty = 'E'.

reward if useful..

Re: Inner join problem

Former Member — Wed, 12 Apr 2006 06:44:04 GMT

Naim,

Its a simple mistake

select a_{equnr a}tplnr a~werk

b_{equnr b}werks b~stlnr

from v_equi as a

inner join eqst as b

on a_{equnr = b}equnr

into corresponding fields of table it_eqst

where a~equnr in equp_no.

if sy-subrc = 0.

select stlnr stlkn idnrk posnr

from stpo

into corresponding fields of table t_stpo

for all entries in t_eqst

where stlnr = t_eqst-stlnr and

stlty = 'E'.

Every field that exist in both the tables should be accompanied by the table name.

Regards,

Ravi

Note : Please close the thread if this solves the issue.

Re: Inner join problem

Former Member — Wed, 12 Apr 2006 06:44:11 GMT

Just make the following correction:

select a_{equnr a}tplnr a~werk

b_{equnr b}werks b~stlnr

from v_equi as a

inner join eqst as b

on a_{equnr = b}equnr

into corresponding fields of table it_eqst

**where equnr in equp_no.

where a~equnr in equp_no.