Get Example source ABAP code based on a different SAP table
ARTICLE
Open SQL in Release 4.0
INNER JOIN and LEFT OUTER JOIN It is now possible to read records from multiple logically associated database tables using a single SELECT command. This can be done using the new constructs INNER JOIN and LEFT OUTER JOIN in the FROM clause. In the past this was normally done using a nested SELECT loop. Replacing these loops with joins produces greatly improved runtime performance.
Subqueries Subqueries are now possible in the WHERE conditions of SELECT, UPDATE, and DELETE commands. Tasks that previously required multiple SQL statements can now be solved more efficiently. A description of these subqueries is available in the documentation of the WHERE clause.
HAVING Clause The new HAVING clause makes it possible to define further conditions for a set of results of a SELECT command created using aggregation and grouping.
