Report2.sql
Upload User: fangwenmm
Upload Date: 2014-06-18
Package Size: 6955k
Code Size: 0k
Development Platform:

Visual C++

  1. USE Stock
  2. GO
  3. CREATE VIEW dbo.Report2
  4. AS
  5. SELECT SiType, Pid, Pprice, Pnum, (Pprice * Pnum) As Amount, Cid, Sid, EmpName, OptDate FROM StoreIn
  6. UNION 
  7. SELECT Ttype, Pid, Pprice, Pnum, (Pprice * Pnum) As Amount, Cid, Sid, EmpName, OptDate FROM TakeOut
  8. GO