T-SQL查询

Question

    SELECT t1.detail_Date AS clmDate
    ,t1.detail_agentID AS clmPID
    ,t3.HODCode AS clmHOD
    ,t1.detail_CallsHandled AS clmIBConnects
    ,t1.detail_TalkTime AS clmIBTalk
    ,t1.detail_WrapTime AS clmIBWrap
    ,t1.detail_HoldTime AS clmIBHold
    ,t1.detail_HandleTime AS clmIBTotal
    ,Sum(IIf([fldCallRoute.Value] = [Inbound],0)) AS clmIBConnects
--  ,Sum(IIf([fldCallRoute] = "Inbound", [clmTalk], 0)) AS IBTalk
--  ,Sum(IIf([fldCallRoute] = "Inbound", [clmWrap], 0)) AS IBWrap
--  ,Sum(IIf([fldCallRoute] = "Inbound", [clmTalk] + [clmWrap] + [clmHold], 0)) AS IBTotal
    ,Sum(0) AS clmOBSignedOn
    ,Sum(0) AS Preview
    ,Sum(0) AS OBTalk
    ,Sum(0) AS OBUpdate
    ,Sum(0) AS OBWork
    ,Sum(0) AS OBConnects
--  ,Sum(IIf([fldCallRoute] = "Inbound", [clmHold], 0)) AS IBHold
--  ,Sum(IIf([fldCallRoute] = "Outbound", [clmHold], 0)) AS OBHold}

我得不到总和(iif..更具体地说，查询的一部分：,Sum(IIf([fldCallRoute] = "Inbound", [clmIBConnects], 0)) AS clmIBConnects

它显示无效的列名'Inbound‘无效的列名'clmIBConnects'？

fldCallRoute列在表t2中，该表具有入站条目，所以我不确定为什么它说的是列名入站？