Error in join query

[Former Member]

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]

Hi tushar

Just write your varaible in bracket as:

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

Regards

Ashish Jain

[former_member182371]

Hi,

try with

INTO (XSTEUS, XKTSCH, XLTXA1)

Best regards.

[Former Member]

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

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

Regards

Ashish Jain

[former_member86837]

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)