Summary
In the chapter we looked at some of the advanced features of SQL, including all the different types of joins: inner, left outer, right outer, and full outer. Star joins, which are used in support of star schemas, were also examined.
SQL can become very useful for solving complex business problems by using such features as CASE expressions, nested table expressions, UNIONs and subqueries. These features allow us to push a lot of business logic into the SQL statement.
Get DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
