22,209
社区成员
发帖
与我相关
我的任务
分享
服务器: 消息 209,级别 16,状态 1,过程 AttCountView,行 5
列名 'Shitname ' 不明确。
服务器: 消息 209,级别 16,状态 1,过程 AttCountView,行 5
列名 'Employeeid ' 不明确。
----------------------------------
错误信息是因为楼主的CheckView3和TempDateShit表中都存在Shitname、Employeeid这两个字段,所以需要在这两个字段前面指定表名。
如:
CREATE VIEW dbo.AttCountView
AS
SELECT CheckView3.Shitname,CheckView3.Employeeid,.... FROM dbo.CheckView3 INNER JOIN TempDateShit ON
CheckView3.SetDate <> TempDateShit.DateSet And CheckView3.ShiftId <> TempDateShit.EmpShitFlag
And CheckView3.EmployeeId <> TempDateShit.Employeeid
CREATE VIEW dbo.AttCountView
AS
SELECT
[Shitname1]=CheckView3.Shitname ,
[Shitname2]=TempDateShit.Shitname,
[Employeeid1]=CheckView3.Employeeid,
[Employeeid2]=TempDateShit.Employeeid,
.........
FROM
dbo.CheckView3
INNER JOIN
TempDateShit ON CheckView3.SetDate=TempDateShit.DateSet And CheckView3.ShiftId=TempDateShit.EmpShitFlag
And CheckView3.EmployeeId=TempDateShit.Employeeid