ASA SQL User's Guide
  Joins: Retrieving Data from Several Tables

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