Syntax error Inner Join?

[Former Member]

Everything was OK till I added last table MBEW for field d~bklas. The field BKLAS does exist in MBEW. Syntax error:wrong table or alias "D"...anybody?...Thank-You!

SELECT a_{matnr a}werks a_{maabc a}dismm

b~maktx

c_{mtart c}matkl c~zzsasi_dept

c_{zzsasi_dept c}zz_sasi_sub_dept c~zzpos1

c_{zzpos1 c}zzpos2 c_{zzpos3 c}zzpos4 c~zzpos5

d~bklas

INTO CORRESPONDING FIELDS OF TABLE t_outdata

FROM marc AS a INNER JOIN makt AS b

ON a_{matnr = b}matnr

INNER JOIN mara AS c

ON a_{matnr = c}matnr

WHERE a~werks IN s_werks

inner join mbew as d

on a_{matnr = d}matnr

where d~bwkey in s_werks.

[former_member181962]

SELECT a_{matnr a}werks a_{maabc a}dismm

b~maktx

c_{mtart c}matkl c~zzsasi_dept

c_{zzsasi_dept c}zz_sasi_sub_dept c~zzpos1

c_{zzpos1 c}zzpos2 c_{zzpos3 c}zzpos4 c~zzpos5

d~bklas

INTO CORRESPONDING FIELDS OF TABLE t_outdata

FROM marc AS a INNER JOIN makt AS b

ON a_{matnr = b}matnr

INNER JOIN mara AS c

ON a_{matnr = c}matnr

<b>inner join mbew as d

ON a_{matnr = d}matnr</b>

WHERE a~werks IN s_werks

where d~bwkey in s_werks.

[laxmanakumar_appana]

Hi,

Check the where condition , it is written two times.

Laxman

[Former Member]

Consolidate 2 WHERE statements in to one as mentioned.

Thanks,

[former_member927251]

Hi Tom,

Here is the modified query.

SELECT a~matnr a~werks a~maabc a~dismm
b~maktx
c~mtart c~matkl c~zzsasi_dept
c~zzsasi_dept c~zz_sasi_sub_dept c~zzpos1
c~zzpos1 c~zzpos2 c~zzpos3 c~zzpos4 c~zzpos5 
d~bklas


INTO CORRESPONDING FIELDS OF TABLE t_outdata
FROM marc AS a INNER JOIN makt AS b
ON a~matnr = b~matnr
INNER JOIN mara AS c
ON a~matnr = c~matnr
inner join mbew as d
on a~matnr = d~matnr
WHERE a~werks IN s_werks
AND   d~bwkey in s_werks.

<b>Reward points if it helps.</b>

[RichHeilman]

You problem is not with that field, you can't have a WHERE condition in your join logic, it must be a the end.

select a~matnr a~werks a~maabc a~dismm
b~maktx
c~mtart c~matkl 
c~zzsasi_dept
c~zzsasi_dept c~zz_sasi_sub_dept c~zzpos1
c~zzpos1 c~zzpos2 c~zzpos3 c~zzpos4 c~zzpos5
d~bklas
into corresponding fields of table t_outdata
       from marc as a 
          inner join makt as b
             on a~matnr = b~matnr
<b>          inner join mara as c
             on a~matnr = c~matnr</b>
          inner join mbew as d
             on a~matnr = d~matnr
                   where <b> a~werks in s_werks</b>
                      and d~bwkey in s_werks.

Regards,

Rich Heilman

[Former Member]

hi,

SELECT a~matnr ...

b~maktx ..

c~mtart ..

d~bklas ..

INTO CORRESPONDING FIELDS OF TABLE t_outdata

FROM marc AS a

INNER JOIN makt AS b

ON a_{matnr = b}matnr

INNER JOIN mara AS c

ON a_{matnr = c}matnr

inner join mbew as d

on a_{matnr = d}matnr.

WHERE a~werks IN s_werks

and d~bwkey in s_werks.

Also, check this....

SELECT p_{carrid p}connid f_{fldate b}bookid

INTO CORRESPONDING FIELDS OF TABLE itab

FROM ( ( spfli AS p

INNER JOIN sflight AS f ON p_{carrid = f}carrid AND

p_{connid = f}connid )

INNER JOIN sbook AS b ON b_{carrid = f}carrid AND

b_{connid = f}connid AND

b_{fldate = f}fldate )

WHERE p~cityfrom = 'FRANKFURT' AND

p~cityto = 'NEW YORK' AND

f_{seatsmax > f}seatsocc.

Regards,

Richa.

[former_member188685]

Hi,

Try this way..

SELECT a~matnr a~werks a~maabc a~dismm
b~maktx
c~mtart c~matkl c~zzsasi_dept
c~zzsasi_dept c~zz_sasi_sub_dept c~zzpos1
c~zzpos1 c~zzpos2 c~zzpos3 c~zzpos4 c~zzpos5
d~bklas
INTO CORRESPONDING FIELDS OF TABLE t_outdata
    FROM marc AS a 
  INNER JOIN makt AS b
    ON a~matnr = b~matnr
  INNER JOIN mara AS c
      ON a~matnr = c~matnr
   INNER JOIN mbew AS d
       ON d~matnr = c~matnr
WHERE a~werks IN s_werks
INNER JOIN mbew AS d
ON a~matnr = d~matnr
WHERE d~bwkey IN s_werks.

Regards

vijay

[Former Member]

You are selection zzsasi_dept twice. That's not your error, but you might want to look into it.

Rob

[Former Member]

hi tom,

SELECT a_{matnr a}werks a_{maabc a}dismm

b~maktx

c_{mtart c}matkl c~zzsasi_dept

c_{zzsasi_dept c}zz_sasi_sub_dept c~zzpos1

c_{zzpos1 c}zzpos2 c_{zzpos3 c}zzpos4 c~zzpos5

d~bklas

INTO CORRESPONDING FIELDS OF TABLE t_outdata

FROM marc AS a INNER JOIN makt AS b

ON a_{matnr = b}matnr

INNER JOIN mara AS c

ON a_{matnr = c}matnr

inner join mbew as d

on a_{matnr = d}matnr

WHERE a~werks IN s_werks and

d~bwkey in s_werks.

hope this helps.

reward if helpful.

regards,

keerthi.

[Former Member]

HI Tom

You have forgotten <b>ON</b> before mbew.

Regards,

Laxmi

[Former Member]

Your correct code is as follows

SELECT a~matnr            a~werks a~maabc a~dismm
       b~maktx            c~mtart c~matkl c~zzsasi_dept
       c~zz_sasi_sub_dept c~zzpos1 c~zzpos2
       c~zzpos3           c~zzpos4 c~zzpos5 d~bklas
  INTO CORRESPONDING FIELDS OF TABLE t_outdata
  FROM marc AS a INNER JOIN makt AS b ON a~matnr = b~matnr
                 INNER JOIN mara AS c ON a~matnr = c~matnr
                 INNER JOIN mbew AS d ON a~matnr = d~matnr
 WHERE a~werks IN s_werks
   AND d~bwkey IN s_werks.