子查询中的访问别名

您不能直接使用列名吗？喜欢..

SELECt Inc.OwnerIdName as OIN  ,(SELECT COUNT(*)    FROM Incident     WHERe CreatedOn BETWEEN '2011/1/1' AND '2011/1/31'    AND Incident.OwnerIdName = Inc.OwnerIdName ) as CasesOpened  ,(SELECt COUNT(*)    FROM IncidentResolution     WHERe ActualEnd BETWEEN '2011/1/1' AND '2011/1/31' AND Incident.OwnerIdName = Inc.OwnerIdName ) as CasesClosedFROM Incident Inc

如果要直接使用Alias，则必须在查询的早期进行此 *** 作，然后将其用于所有标量子查询。

SELECt INC.OIN  ,(SELECT COUNT(*)    FROM Incident     WHERe CreatedOn BETWEEN '2011/1/1' AND '2011/1/31'    AND Incident.OwnerIdName = INC.OIN ) as CasesOpened  ,(SELECt COUNT(*)    FROM IncidentResolution     WHERe ActualEnd BETWEEN '2011/1/1' AND '2011/1/31' AND Incident.OwnerIdName = INC.OIN ) as CasesClosedfrom (Select OwnerIdName OIN  FROM Incident) INc