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

You can now read records from multiple logically linked database tables with a single SELECT command. This can be done with the new constructs INNER JOIN and LEFT OUTER JOIN in the FROM clause. In the past this was normally done with a nested SELECT loop. Replacing these loops with joins results in a 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. You can find a description of the subqueries in the documentation on the WHERE clause under Logical Condition.

HAVING Clause

The new HAVING clause permits you to define further conditions for a set of results of a SELECT command created by aggregation and grouping.