8建库存视图storage.sql

仓库管理系统

/* 创建视图storage（仓库名，商品号，商品名，库存量，单价，颜色）*/
create view storage(depot_name,goods_id,goods_name,total,goods_p,color)
as
select depot.depot_name,goods_total.gt_gid,goods_name,total,goods_p,goods_color
from goods,depot,goods_total
where goods.goods_id=goods_total.gt_gid and depot.depot_id=goods_total.gt_did