------------入库流水表\入库明细表
select a.rkbh,a.bumenid,a.shsj,b.goodsid,b.goodsqty,b.ph
from zp_goods_rkls a,zp_goods_rkmx b
where a.rkbh=b.rkbhRKBH BUMENID SHSJ GOODSID GOODSQTY PH
41 60000000 2010-3-19 13:30:32 67 3 0
41 60000000 2010-3-19 13:30:32 64 1000 200910
41 60000000 2010-3-19 13:30:32 63 2 200910
43 90000000 2010-3-19 13:30:28 65 20 2008
43 90000000 2010-3-19 13:30:28 65 10 2008
43 90000000 2010-3-19 13:30:28 65 5 2007--------------移库流水表\移库明细表
select c.ykbh,c.shsj,c.fombumenid,c.tobumenid,d.goodsid,d.goodsqty
,d.ph from zp_goods_ykls c ,zp_goods_ykmx d where
c.ykbh=d.ykbh 数据如下
YKBH SHSJ FOMBUMENID GOODSID GOODSQTY PH
126 2010-3-19 16:03:19 50000000 65 5 200
126 2010-3-19 16:03:19 50000000 64 100 0输入一个goodsid(假设是64) 查询到的格式是
操作时间 商品ID 数量 批号 部门ID 单据号 单据类型
2010-3-19 16:03:19 64 100 0 50000000 126 移库
2010-3-19 13:30:32 64 1000 200910 60000000 41 入库
单据类型(goodsid在zp_goods_ykmx中就显示移库在zp_goods_rkmx就显示入库)
select a.rkbh,a.bumenid,a.shsj,b.goodsid,b.goodsqty,b.ph
from zp_goods_rkls a,zp_goods_rkmx b
where a.rkbh=b.rkbhRKBH BUMENID SHSJ GOODSID GOODSQTY PH
41 60000000 2010-3-19 13:30:32 67 3 0
41 60000000 2010-3-19 13:30:32 64 1000 200910
41 60000000 2010-3-19 13:30:32 63 2 200910
43 90000000 2010-3-19 13:30:28 65 20 2008
43 90000000 2010-3-19 13:30:28 65 10 2008
43 90000000 2010-3-19 13:30:28 65 5 2007--------------移库流水表\移库明细表
select c.ykbh,c.shsj,c.fombumenid,c.tobumenid,d.goodsid,d.goodsqty
,d.ph from zp_goods_ykls c ,zp_goods_ykmx d where
c.ykbh=d.ykbh 数据如下
YKBH SHSJ FOMBUMENID GOODSID GOODSQTY PH
126 2010-3-19 16:03:19 50000000 65 5 200
126 2010-3-19 16:03:19 50000000 64 100 0输入一个goodsid(假设是64) 查询到的格式是
操作时间 商品ID 数量 批号 部门ID 单据号 单据类型
2010-3-19 16:03:19 64 100 0 50000000 126 移库
2010-3-19 13:30:32 64 1000 200910 60000000 41 入库
单据类型(goodsid在zp_goods_ykmx中就显示移库在zp_goods_rkmx就显示入库)
select * from (
select a.shsj [操作时间],b.goodsid [商品ID],b.goodsqty [数量],
b.ph [批号],a.bumenid [部门ID],a.rkbh [单据号], '入库' [单据类型]
from zp_goods_rkls a,zp_goods_rkmx b where a.rkbh=b.rkbh
union all
select c.shsj,d.goodsid,d.goodsqty,d.ph,c.fombumenid,c.ykbh, '移库' [单据类型]
from zp_goods_ykls c ,zp_goods_ykmx d where c.ykbh=d.ykbh ) t
where [商品ID]=64