>>

>>SELECT gsf1.*, classify.classcode, classify.classgrup ;
>>    FROM gsf1 ;
>>        LEFT JOIN classify ON gsf1.contactno = classify.contactno ;
>>   WHERE classify.classgrup = 'JOBTYPE'
>>

>Right, but that gives the wrong results. This won't pick up any records without
>Jobtypes, but I want all the contacts, whether or not they have a
>jobtype. The following query will probably do the right thing....

>SELECT gsf1.*, NVL(classify.classcode, 'BLANK     ') AS classcode, ;
>    NVL(classify.classgrup, 'JOBTYPE   ') AS classgrup ;
>    FROM gsf1 ;
>        LEFT JOIN classify ON gsf1.contactNo = classify.contactNo ;
>    WHERE classify.classgrup = 'JOBTYPE'

Actually, it didn't do the right thing. :-( Problem is, most of the contacts without job types have some other classification, so this is still effectively an inner join. :-( I'll go with what I have for now, I guess....