topic Re: Syntax error Inner Join? in Application Development and Automation Discussions

Syntax error Inner Join?

Former Member — Thu, 22 Jun 2006 15:38:45 GMT

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.

Re: Syntax error Inner Join?

Former Member — Thu, 22 Jun 2006 15:41:10 GMT

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

where d~bwkey in s_werks.

Re: Syntax error Inner Join?

Laxmana_Appana_ — Thu, 22 Jun 2006 15:42:04 GMT

Hi,

Check the where condition , it is written two times.

Laxman

Re: Syntax error Inner Join?

Former Member — Thu, 22 Jun 2006 15:43:33 GMT

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.

Reward points if it helps.

Re: Syntax error Inner Join?

Former Member — Thu, 22 Jun 2006 15:43:50 GMT

Consolidate 2 WHERE statements in to one as mentioned.

Thanks,

Re: Syntax error Inner Join?

RichHeilman — Thu, 22 Jun 2006 15:43:53 GMT

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

Re: Syntax error Inner Join?

Former Member — Thu, 22 Jun 2006 15:48:03 GMT

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.

Re: Syntax error Inner Join?

Former Member — Thu, 22 Jun 2006 15:56:49 GMT

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

Re: Syntax error Inner Join?

Former Member — Thu, 22 Jun 2006 16:14:20 GMT

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

Rob

Re: Syntax error Inner Join?

Former Member — Thu, 22 Jun 2006 16:36:48 GMT

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.

Re: Syntax error Inner Join?

Former Member — Thu, 22 Jun 2006 16:40:18 GMT

HI Tom

You have forgotten ON before mbew.

Regards,

Laxmi

Re: Syntax error Inner Join?

Former Member — Thu, 22 Jun 2006 16:44:50 GMT

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.