SELECT DISTINCT sr_stu_enroll.campus_id,
      sr_stu_enroll.stu_id,
      sr_stu_enroll.name_l, sr_stu_enroll.name_f, sr_stu_enroll.name_m,
      sr_spec_pgm_spec_ed.speech_thrpy_ind
FROM  sr_stu_enroll, sr_spec_pgm_spec_ed
WHERE sr_stu_enroll.stu_id = sr_spec_pgm_spec_ed.stu_id and 
      trim(sr_spec_pgm_spec_ed.speech_thrpy_ind) = ''
ORDER BY sr_stu_enroll.campus_id,
         sr_stu_enroll.stu_id;
output to c:\blank_speech.txt