topic Re: Error in join query in Application Development and Automation Discussions

Error in join query

Former Member — Thu, 18 Aug 2005 16:22:19 GMT

I get error in following querY sAying "Unable to interpret XKTSCH".

report ZTF1.

tables: AFKO, AFVC.

DATA: XSTEUS LIKE AFVC-STEUS,

XKTSCH LIKE AFVC-KTSCH,

XLTXA1 LIKE AFVC-LTXA1.

SELECT SINGLE AFVC_{STEUS AFVC}KTSCH AFVC~LTXA1 FROM

AFVC INNER JOIN AFKO

ON AFVC_{AUFPL = AFKO}AUFPL

INTO XSTEUS XKTSCH XLTXA1

where AFKO_{AUFNR = '007200000059' and AFVC}VORNR = '0010'.

WRITE:/ XSTEUS.

WRITE:/ XKTSCH.

WRITE:/ XLTXA1.

Former Member — Thu, 18 Aug 2005 16:25:17 GMT

Hi tushar

Just write your varaible in bracket as:

.. INTO ( XSTEUS XKTSCH XLTXA1 ) where ...

Regards

Ashish Jain

former_member182371 — Thu, 18 Aug 2005 16:25:45 GMT

Hi,

try with

INTO (XSTEUS, XKTSCH, XLTXA1)

Best regards.

Former Member — Thu, 18 Aug 2005 16:27:26 GMT

Sorry, you need to put space after '{' and '}'

..... INTO ( XSTEUS XKTSCH XLTXA1 ) where....

Regards

Ashish Jain

former_member86837 — Fri, 19 Aug 2005 08:15:28 GMT

Actually the previous answer is the correct one syntactically. If you add spaces after the brackets you will get a syntax error.

correct:

INTO (XSTEUS, XKTSCH, XLTXA1)