The following programs demonstrate the use of the CROSS clause to
join records from two relations (a non-equijoin). These programs
join the relations CURRENT_JOB and JOBS over their common field
JOB_CODE. This allows these programs to print a report that
contains fields from both relations. Specifically, these fields
are: LAST_NAME from the CURRENT_JOBS relation, JOB_CODE from the
JOBS relation, and JOB_TITLE from the JOBS relation.
Additional Information:
explode
extract