SAP NEWS-40-OPEN-SQL documentation, setup help and example usage

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 .