/* 創(chuàng)建視圖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