Specialized joins

This section describes how to create some specialized joins such as self-joins, star joins, and joins using derived tables.


Self-joins
Duplicate correlation names in joins (star joins)
Joins involving derived tables
Joins resulting from apply expressions