Facing error in sql query.

[amysh95]

Hey,

am facing an error while writing sql query. I am using gui7.2.

error: If the new OpenSQL syntax is used, it must be used throughout. This includes using @ to escape host variables.

what is this. my code is:

SELECT SINGLE * FROM
ADRCT LEFT JOIN TVKO
ON ADDRNUMBER = TVKO-ADRNR
INTO ADRCT
WHERE TVKO-BUKRS = VBRK-BUKRS.

I also tried this.

SELECT SINGLE * FROM
ADRCT LEFT JOIN TVKO
ON ADDRNUMBER = TVKO-ADRNR
INTO (@ADRCT)
WHERE TVKO-BUKRS = VBRK-BUKRS.

but still facing error.

[Sandra_Rossi]

Don't use host expressions at all (don't use @) or use only host expressions (@ in front of all variables)

[DoanManhQuynh]

(@ADRCT) should be @ADRCT only, no bracket, where condition also need @.

Also, for join sql you have to use ~ instead of -.

[matt]

Read the ABAP help on the syntax of select.