【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“v_Sts.sql”一文,供大家参考学习!
USE Mis
GO
CREATE VIEW dbo.v_Sts
AS
SELECT dbo.SalaryStatistics.EmpId, dbo.Employees.EmpName,
dbo.SalaryItem.ItemName, dbo.SalaryStatistics.Total, dbo.SalaryStatistics.ItemId,
dbo.SalaryItem.IsVisible, dbo.SalaryStatistics.iMonth
FROM dbo.Employees INNER JOIN
dbo.SalaryStatistics ON
dbo.Employees.EmpId = dbo.SalaryStatistics.EmpId INNER JOIN
dbo.SalaryItem ON dbo.SalaryStatistics.ItemId = dbo.SalaryItem.ItemId
WHERE (dbo.SalaryItem.IsVisible = 1)
ORDER BY dbo.SalaryItem.ItemType