Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Nested SQL query in ABAP

Hi experts,

I would like to know how can I translate this nested SQL statement into an ABAP query (both MyTable1 and MyTable2 have as primary key the field "myfield"):

SELECT t1.myfield

FROM MyTable1 as t1

WHERE t1.myfield NOT IN (SELECT t2.myfield

FROM MyTable2 as t2)

Full points available

Thank you

Francesco

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question