Explicit Joins Overview

When querying to retrieve results from tables with no predefined integrity constraint, you can use an explicit join condition. To define a join condition, you specify the columns on each table which provide the join, for example the PROJ_ID columns in the TASK and PROJECT tables.