ABAP Keyword Documentation →  ABAP - Release-Specific Changes →  Changes in Releases 4.0 and 4.5 

Open SQL in Release 4.0

Other versions: 7.31 | 7.40 | 7.54

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.