开立销售单据后,打开销售汇总表,发现汇总
A问题解答
A、select count(*) from goods,select count(*) from goodsunit ,通过此查询记录,判断两表的合计数是否一致,select * from saledetail where price<>unitprice or quanitity<>unitqty
通过此查询语句,判断销售开单从表是否存在记录
,update saledetail set price=unitprice and quantity=unitqty where price<>unitpri