v_yaopin_list.txt

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

CREATE VIEW dbo.v_yaopin_list
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, b.pifa, b.zuidi, b.zuigao, b.zuihou, b.zhekou, c.unit, c.switch, 
      c.price
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