How to use sub select & left outer join?

[#1]

I'm trying to perform the below sql-statement:

But there I got a syntax error on line 43, which says the select statement is not allowed here.

I tried also

the error message says "SELECT" is in ABAP-Dictionay not as table, projection or db-view declaerd. Finally I modified the sql statement as below

and got the error message: 'JOIN' was expected here.

How can sub select be used after a left outer join or inner join statement as table correctly?

[Former Member]

Because there is only one condition (vbrl~zz_fbuda_min in datum) after WHERE clause, I have decided to put this condition after ON clause. I think the implication will be the same. Please correct me if I'm wrrong. At the moment my sql query looks like below

But the question is and remains, how a sub select can be used after a LlEFT OUTER JOIN resp. INNER JOIN?

[Ankit_Maskara]

You can check here for Select subquery syntax with Inner Join - https://archive.sap.com/discussions/thread/1326078.

Still from performance perspective I will not advise your select query.

Please avoid select....endselect and in the where clause use positive conditions like IN or EQ etc. Using negatives line <> degrades the runtime.