这是我的声明:
SELECT
C.Account,
(RTRIM(N.FIRST) + ' ' + RTRIM(LTRIM(N.MIDDLE)) + ' ' + RTRIM(LTRIM(N.LAST)) + ' ' + LTRIM(N.SUFFIX)) AS OwnerName,
DateAdd(dd, -1, C.ExpirationDate) as RealExpirationDate,
C.Description,
C.Type
FROM CARD as C
INNER JOIN NAME as N ON C.Account = N.Account
WHERE (RealExpirationDate BETWEEN @StartDate AND @EndDate)
AND C.Type IN(10,15,17,25)
我不断收到错误消息RealExpirationDate
是无效的列名。我如何引用该别名?
你不能在上面的代码中,记住WHERE
发生在之前SELECT
,所以你必须使用:
WHERE DateAdd(dd, -1, C.ExpirationDate) BETWEEN @StartDate AND @EndDate
最常见的别名类似的方法是一些内部视图/查询,如下所示:
SELECT
n.FooBar, --here we can use FooBar
t.BarFoo
FROM
MyTable t
INNER JOIN
(
SELECT
myTestCase as FooBar
From MyTable2
) n
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)