Use table alias in table join : Introduction « Table Joins « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Table Joins
3. Introduction

SQL>
SQL> CREATE TABLE employee (
  2  id           number,
  3  name         varchar(100),
  4  birth_date   date,
  5  gender       varchar2(30) );

Table created.

SQL>
SQL> CREATE TABLE employee_evaluation (
  2  id           number,
  3  title        varchar2(100),
  4  written_date date );

Table created.

SQL>
SQL>
SQL> SELECT a.id,
  2         a.name,
  3         p.title,
  4         p.written_date
  5  FROM   employee a,
  6         employee_evaluation p
  7  WHERE  a.id = p.id
  8  ORDER BY a.name,
  9         p.written_date,
 10         p.title;

no rows selected

SQL>
SQL> drop table employee;

Table dropped.

SQL>
SQL> drop table employee_evaluation;

Table dropped.