无效的列名

大不丢儿

SELECT Ad.Id, Newspaper,
    (select Organization from JobOrganization where JobOrganization.Id = Ad.OrganizationId) as Organization,
3 w$ ?) U0 G. X$ J  K& S& Z1 ~4 P# k    Ad.PublishDate, Ad.LastDate,Ad.Url, Job.Id as JobId,
6 k. c; h; q* L- ]3 `( B2 _/ I    (select JobTitle from JobTitle where JobTitle.Id = Job.TitleId) as JobTitle1,
$ j; }6 Z" p" k" B. ~5 m7 Q    QualificationId, ExpInYears, CategoryId
' ^. Q9 ~* T. P3 m3 C% J. g0 C) r: [     FROM Ad inner join Job on Ad.Id = Job.AdId
% g& C  w9 ^( E+ D& U     Where JobTitle1 Like @title or @title is null
     Order by
case When @sortCol='PublishDate' and @sortDir='ASC' Then Ad.PublishDate End ASC,
! `! k4 I  k5 N case When @sortCol='PublishDate' and @sortDir='DESC' Then Ad.PublishDate End DESC,
case When @sortCol='LastDate' and @sortDir='ASC' Then Ad.LastDate End ASC,
case When @sortCol='LastDate' and @sortDir='DESC' Then Ad.LastDate End DESC
* }9 Q- h9 w, G4 S# G, |错误：列名’JobTitle1’无效。
, o# t0 u* }- e* g我正在使用SQL-2008
               
; l6 A. R4 N) c- w  ^$ a解决方案: