如何查询ERP流水期末库存与库存表实物库存不一致
SELECT *
FROM scm_product_stock RIGHT OUTER JOIN
(select * from scm_product_running_list where id in (select max(id) from scm_product_running_list where operating_center_inner_id=''100000'' group by product_code) ) cs_view ON scm_product_stock.product_code = cs_view.product_code AND
scm_product_stock.operating_center_inner_id = cs_view.operating_center_inner_id where sum_quantity<>end_quantity
该文章在 2018/11/13 22:53:50 编辑过