【SQL开源代码栏目提醒】:网学会员鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“Report2.sql”一文,供大家参考学习
CREATE VIEW dbo.Report2
AS
SELECT StoreinId, StoreinType, ProId, ProPrice, ProNum, (ProPrice * ProNum) As Amount, ClientId, StoreId, EmpName, OptDate FROM StoreIn
UNION SELECT TakeoutId, TakeoutType, ProId, ProPrice, ProNum, (ProPrice * ProNum) As Amount, ClientId, StoreId, EmpName, OptDate FROM TakeOut