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> 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.