error message appears ?

[Former Member]

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.

[Former Member]

Attach your code.

[RichHeilman]

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

[anversha_s]

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

on

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

[Former Member]

Hi,

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

Hope this helps.

[Former Member]

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.

[Former Member]

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