can anyone help turn the light on in my head...what's wrong with this sql statemetn?

SELECT DISTINCT V_htclist.htc_id, V_htclist.htc_name, V_htclist.fax_it;
FROM udc2!v_htclist, udc2!valerrors;
where V_htclist.htc_id = Valerrors.htc_id ;
and in (select htc_id from v_terror where htc_id != v_htclist.htc_id) ;
into cursor jeff