Table Alias « Table Joins « Oracle PL/SQL Tutorial

7.2.Table Alias
7.2.1.List table from two tables without indicating column owner
7.2.2.List table from two tables and specifying its column owner
7.2.3.Join tables and order by columns from different tables
7.2.4.Calculation between column from different tables
7.2.5.Join two tables and combine three tables
7.2.6.Supplying Table Aliases
7.2.7.Use * to reference all columns from a table
7.2.8.Reference column without table name during table join