关于库存问题,应该怎么改
select pro_code, pro_name, pro_spec,pro_unit,pro_inprice,sum(rksl) rksl, sum(cksl) cksl, sum(kcl) kcl
from (
select pro_code, pro_name, pro_spec,pro_unit,pro_inprice, rksl, 0 cksl, rksl kcl
from rkmx
union
select pro_code, pro_name,pro_spec,pro_unit, 0 rksl, cksl, -cksl kcl
from lkmx
)
group by pro_code
我写在库存查询的open页,然后错误。我应该怎么改,或者写在哪
pb SQL
------解决方案--------------------
不懂你在讲什么.....