>Keep SQL simpler:
>SELECT ssno ;
>FROM helth_priors_tmp ;
>INTO cursor tmp1 ;
>UNION SELECT ssno FROM helth_currents_tmp
>
>SELECT dedtype, mnpd, name, prsnid, unit, div, dept, subdept,;
>eeclascd, prioradj, ssno, sortkey, famsingl, frfamsng, dedamnt,;
>termcode, paidthru, addcode, adjamt, adjmonth, efctdate,;
>user_comment;
>FROM helthins_view ;
>INTO cursor cHelth_tmp3 ;
>WHERE ssno NOT IN (SELECT ssno FROM tmp1)

Thanks Edward!