report2.sql

来自「这是一个用visual c＋＋&sql server开发的关于企业库存管理的信息」· SQL 代码 · 共 9 行

USE Stock
GO
CREATE VIEW dbo.Report2
AS
SELECT SiType, Pid, Pprice, Pnum, (Pprice * Pnum) As Amount, Cid, Sid, EmpName, OptDate FROM StoreIn
UNION 
SELECT Ttype, Pid, Pprice, Pnum, (Pprice * Pnum) As Amount, Cid, Sid, EmpName, OptDate FROM TakeOut
GO