📄 v_stock.txt
字号:
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
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -