>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 classifications, 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'You can be so much more productive when you go out to a baseball game in the middle of a case of brainlock....