建库存视图.sql

仓库管理系统

/*创建视图goods-total（仓库号，商品号，商品名，库存量，）*/
create view goods_total(gt_did,gt_gid,total)
  as 
select goods_in.depot_id,goods_in.goods_id,goods_in.in_total-goods_out.out_total
from goods_in left join goods_out on (goods_in.depot_id=goods_out.depot_id and goods_in.goods_id=goods_out.goods_id)