using a join on 2 tables select all columns and

Question

Using a Join on 2 tables, select all columns and all rows from the tables without the use of a Cartesian product.

Query:

SELECT * FROM EMPLOYEE1 JOIN CONTRACT ON EMPLOYEE1.EMP_ID=CONTRACT.EMP_ID;

Select and Order data retrieved from one table

Query:

            SELECT * FROM EMPLOYEE1 ORDER BY LAST_NAME;