Select fields from 2 tables

[former_member588495]

Greeting,

I am learning ABAP and trying to select fields from 2 tables(AFKO & RESB), following is my script:

==============================================================

SELECT A-AUFNR B-MATNR B-WERKS B-LGORT B-BDMNG
FROM AFKO AS A
LEFT JOIN RESB AS B ON A-RSNUM = B-RSNUM

==============================================================

However, when I click on 'Check' button, system showed an error message: Field "A-RSNUM" unknown, is there any experts could tell me where I need to modify?

Thanks in advance

Roger

[FredericGirod]

SELECT A~AUFNR B~MATNR B~WERKS B~LGORT B~BDMNGFROM AFKO AS ALEFT JOIN RESB AS B ON A~RSNUM = B~RSNUM

Tilde not minus

[former_member588495]

Dear Frederic,

I got it, thank you.

Best Regards

Roger