“POS销售汇总表”与“POS销售明细表

问题分析： 业务单位数量（quantity）与基本单位数量（unitqty）不一致 解决方法： A、 select * from goods where goodsid in(select goodsid from goodsunit group by goodsid having count(goodsid)>1) order by goodsid /*检查是否存在多单位货品*/ B、select * from posdetail where quantity<>unitqty /*检查是否存在业务单