无效的列名

大不丢儿

SELECT Ad.Id, Newspaper,
0 d5 o/ {4 H" D( i    (select Organization from JobOrganization where JobOrganization.Id = Ad.OrganizationId) as Organization,
) l( T. ]$ f) P* v; h; ^6 ^  v5 Y    Ad.PublishDate, Ad.LastDate,Ad.Url, Job.Id as JobId,
+ q; n1 \' `9 x6 H) D; k1 h0 M    (select JobTitle from JobTitle where JobTitle.Id = Job.TitleId) as JobTitle1,
  t: E, A, P2 C0 V( |& |  P! G    QualificationId, ExpInYears, CategoryId
     FROM Ad inner join Job on Ad.Id = Job.AdId
     Where JobTitle1 Like @title or @title is null
) x, @8 Z% s  f. J1 A0 K8 ]     Order by
case When @sortCol='PublishDate' and @sortDir='ASC' Then Ad.PublishDate End ASC,
6 k9 N) a: \' n) @: L case When @sortCol='PublishDate' and @sortDir='DESC' Then Ad.PublishDate End DESC,
case When @sortCol='LastDate' and @sortDir='ASC' Then Ad.LastDate End ASC,
4 G4 v; [7 C/ Y case When @sortCol='LastDate' and @sortDir='DESC' Then Ad.LastDate End DESC
错误：列名’JobTitle1’无效。
- f+ b0 j* ~- w% @0 B7 J" k我正在使用SQL-2008
. ]* E" p% J# e7 o               
$ w' a9 S: A$ R. W  n解决方案: