>SELECT lv_icitem_desc.item , lv_icitem_desc.itmclss ;
> FROM lv_icitem_desc WHERE item NOT IN ;
> (SELECT DISTINCT item_no as item FROM lv_inv_count) ;
> order by 2,1 having val(itmclss) > 5
You can only use the HAVING clause in conjunction with a GROUP BY. It is like a WHERE for a group. Is there a reason you're not just using WHERE VAL(itmclss) > 5?
Erik Moore
Clientelligence