The following programs demonstrate the use of the FIRST FROM
clause. The programs find the first record in the JOBS relation
with the value "Company President" in the field JOB_TITLE. Using
this record's value for JOB_CODE, these programs create a record
stream containing the records in the CURRENT_JOB relation that
have this same job code. The programs print the value that the
first record from this record stream holds in the LAST_NAME
field.
Additional Information:
explode
extract