【SQL开源代码栏目提醒】:网学会员鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“v_TakeOut.sql”一文,供大家参考学习
CREATE VIEW dbo.v_takeout
AS
SELECT p.ProId, SUM(t.ProNum) AS SumNum, SUM(t.ProNum * t.ProPrice)
AS SumPrice
FROM dbo.Product p INNER JOIN
dbo.TakeOut t ON p.ProId = t.ProId
GROUP BY p.ProId