v_yaopin_list.txt

< 飞鸿商品>>零售是基于VB+SQL2000开的商品零售管理系统. 开发的很好.可以一看

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