v_sts.sql

来自「财务管理系统 报账等基本功能实现 有完整的实现」· SQL 代码 · 共 13 行

USE Mis
GO
CREATE VIEW dbo.v_Sts
AS
SELECT TOP 100 PERCENT 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