error in inner join

[Former Member]

Hi All,

I have written an inner join statement as given below but it is giving an error "LOEKZ has two meanings".what could be wrong?

SELECT a_{BANFN a}BNFPO a_{WERKS a}EKGRP a_{MATNR a}TXZ01 a_{ERNAM a}FRGKZ

a_{FRGDT a}FRGST a_{BADAT a}ERDAT a_{EBELN a}EBELP a_{BEDAT a}STATU

a_{MATKL a}BEDNR a_{BSART a}AFNAM a_{BSTYP a}FLIEF b~KOSTL

into corresponding fields of table t_eban

from EBAN as a inner join ebkn as b

on a_{banfn = b}banfn

AND a_{bnfpo = b}bnfpo

where flief eq flief

and kostl eq b~kostl

and LOEKZ NE 'X'.

Thanks,

Rakesh More.

[Former Member]

Hi

Hi in the where condn you have say LOEKZ field is from EBAN or from EBKN tables. write accordingly a or b with field like below:

SELECT a_{BANFN a}BNFPO a_{WERKS a}EKGRP a_{MATNR a}TXZ01 a_{ERNAM a}FRGKZ

a_{FRGDT a}FRGST a_{BADAT a}ERDAT a_{EBELN a}EBELP a_{BEDAT a}STATU

a_{MATKL a}BEDNR a_{BSART a}AFNAM a_{BSTYP a}FLIEF b~KOSTL

into corresponding fields of table t_eban

from EBAN as a inner join ebkn as b

on a_{banfn = b}banfn

AND a_{bnfpo = b}bnfpo

where flief eq flief

and a_{kostl eq b}kostl

and a~LOEKZ NE 'X'.

Reward points if useful

Regards

Anji

[Former Member]

See the below code :

SELECT a_{BANFN a}BNFPO a_{WERKS a}EKGRP a_{MATNR a}TXZ01 a_{ERNAM a}FRGKZ

a_{FRGDT a}FRGST a_{BADAT a}ERDAT a_{EBELN a}EBELP a_{BEDAT a}STATU

a_{MATKL a}BEDNR a_{BSART a}AFNAM a_{BSTYP a}FLIEF b~KOSTL

into corresponding fields of table t_eban

from EBAN as a inner join ebkn as b

on a_{banfn = b}banfn

AND a_{bnfpo = b}bnfpo

where a_{flief eq b}flief

and a_{kostl eq b}kostl

and a~LOEKZ NE 'X'.

Reward Points if it is useful

Thanks

Seshu

[Former Member]

Hi Rakesh,

Instead of just giving LOEKZ. Write it as a_{LOEKZ 'OR" b}LOEKZ. The error is because of ambiguity as LOEKZ is there in both EBAN & EBKN.

Regards,

Younus

Reward Helpful Answers!!!!

[Former Member]

put like this

<b>and EBAN~LOEKZ NE 'X'</b>

Regards

Prabhu

[Former Member]

hi

it means that the field used in where clause is existing in more than one table that you have used in your select statement...so you have to specify which table's LOEKZ in your select statement...change it as follows

SELECT a_{BANFN a}BNFPO a_{WERKS a}EKGRP a_{MATNR a}TXZ01 a_{ERNAM a}FRGKZ

a_{FRGDT a}FRGST a_{BADAT a}ERDAT a_{EBELN a}EBELP a_{BEDAT a}STATU

a_{MATKL a}BEDNR a_{BSART a}AFNAM a_{BSTYP a}FLIEF b~KOSTL

into corresponding fields of table t_eban

from EBAN as a inner join ebkn as b

on a_{banfn = b}banfn

AND a_{bnfpo = b}bnfpo

where flief eq flief

and kostl eq b~kostl

and a_{LOEKZ NE 'X'. --> specifies eban's loekz or b}loekz - ebkn's loekz

if helpful, reward

Sathish. R

[former_member632991]

Hi,

This is because the field LOEKZ is there in both the tables , u have to give as a~LOEKZ in where condition.

Regards,

Sonika

[Former Member]

Hi Rakesh,

U have to take this condition also :

<b> a_{LOEKZ = B}LOEKZ</b>

Use this code :

SELECT a_{BANFN a}BNFPO a_{WERKS a}EKGRP a_{MATNR a}TXZ01 a_{ERNAM a}FRGKZ

a_{FRGDT a}FRGST a_{BADAT a}ERDAT a_{EBELN a}EBELP a_{BEDAT a}STATU

a_{MATKL a}BEDNR a_{BSART a}AFNAM a_{BSTYP a}FLIEF b~KOSTL

into corresponding fields of table t_eban

from EBAN as a inner join ebkn as b

on a_{banfn = b}banfn

AND a_{bnfpo = b}bnfpo

<b>AND a_{LOEKZ = B}LOEKZ</b>

where flief eq flief

and kostl eq b~kostl

and LOEKZ NE 'X'.

Reward points if helpful.

Regards,

Hemant