v_stock.txt

来自「< 飞鸿商品>>零售是基于VB+SQL2000开的商品零售管理」· 文本 代码 · 共 14 行

CREATE VIEW dbo.v_stock
AS
SELECT a.id, a.leibie, a.tiaoma, a.name, a.guige, a.fuma, a.othername, a.shuxing1, 
      a.shuxing2, a.changjia, a.chandi, a.pihao, a.shuilu, a.beizhu, a.kushang, a.kuxia, 
      a.baozhi, b.jihua * c.switch AS jihua, b.pifa * c.switch AS pifa, 
      b.zuidi * c.switch AS zuidi, b.zuigao * c.switch AS zuigao, 
      b.zuihou * c.switch AS zuihou, b.zhekou * c.switch AS zhekou, c.unit, c.switch, c.price, 
      d.num / c.switch AS stock
FROM dbo.yaopin_list a INNER JOIN
      dbo.yaopin_price b ON a.id = b.id RIGHT OUTER JOIN
      dbo.yaopin_unit c ON a.id = c.id INNER JOIN
      dbo.yaopin_num d ON a.id = d.id