>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
...
and fieldname in (select ....
...