topic Re: error message appears ? in Application Development and Automation Discussions

error message appears ?

Former Member — Thu, 21 Sep 2006 14:09:35 GMT

I am using one inner join then i got this message.

what does it means ?

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

Plz help me.

Re: error message appears ?

Former Member — Thu, 21 Sep 2006 14:10:14 GMT

Attach your code.

Re: error message appears ?

RichHeilman — Thu, 21 Sep 2006 14:11:19 GMT

it means that this field is present in both tables of the join, make sure to specify the field that you want like this.

<b>table_name~</b>ntgew.

Regards,

Rich Heilman

Re: error message appears ?

anversha_s — Thu, 21 Sep 2006 14:11:33 GMT

hi,

kindly chk the syntax of ur inner join with

the below sample code and let us know.

hi,

table emp

empno name

a sasi

b xxx

c yyy

table sal

empno salary

a 1000

b 2000

Inner join

****************

select e_{empno e}name

s~sal

into table int_table

from emp as e

inner join sal

e_{empno = s}empno.

if you made inner join between table a and b by emp no

the selection retrives only if the condition satisfy the output will be

a sasi 1000

b xxx 2000

<b>if both tables have same field, u shuld apecifiaccly mention the table name.

table_name~field_name.</b>

rgds

anver

if helped mark points

Re: error message appears ?

Former Member — Thu, 21 Sep 2006 14:12:22 GMT

Hi,

Probably It means that the NTGEW is available in both the tables you are joining.

Hope this helps.

Re: error message appears ?

Former Member — Thu, 21 Sep 2006 14:13:06 GMT

Sample code for Inner join

<b> SELECT a_{serviceid a}service b~sp_name

INTO CORRESPONDING FIELDS OF TABLE i_eservprov

FROM eservprov AS a INNER JOIN eservprovt AS b

ON a_{serviceid = b}serviceid

WHERE a~service = '0007'.</b>

Regards,

Prakash.

Re: error message appears ?

Former Member — Thu, 21 Sep 2006 14:17:23 GMT

Hi Adams,

may be NTGEW field exists in the 2 tables that u r joining

so in the join conditions specify from which table u r using that field

eg : t1~NTGEW