topic Re: error in inner join in Application Development and Automation Discussions

error in inner join

Former Member — Mon, 14 May 2007 04:52:41 GMT

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.

Re: error in inner join

Former Member — Mon, 14 May 2007 04:56:33 GMT

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

Re: error in inner join

Former Member — Mon, 14 May 2007 04:57:03 GMT

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

Re: error in inner join

Former Member — Mon, 14 May 2007 04:57:19 GMT

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!!!!

Re: error in inner join

Former Member — Mon, 14 May 2007 04:57:22 GMT

put like this

and EBAN~LOEKZ NE 'X'

Regards

Prabhu

Re: error in inner join

Former Member — Mon, 14 May 2007 04:57:24 GMT

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

Re: error in inner join

former_member632991 — Mon, 14 May 2007 04:57:39 GMT

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

Re: error in inner join

Former Member — Mon, 14 May 2007 05:00:19 GMT

Hi Rakesh,

U have to take this condition also :

a_{LOEKZ = B}LOEKZ

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

AND a_{LOEKZ = B}LOEKZ

where flief eq flief

and kostl eq b~kostl

and LOEKZ NE 'X'.

Reward points if helpful.

Regards,

Hemant