Alias field names and where clause

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Simon Sabin SSCrazy Eights Points: 8142 More actions · Answer 1

Yep thats right its a really arse sometimes.

If you have a really complex expression put it in a derived table i.e

select fullname

from (

select Name + Surname as Fullname ) as a

where Fullname > 'Paul'

order by Fullname

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

anakin SSC Veteran Points: 272 More actions · Answer 2

I try it in query analizer but raise sintax error, where is the where clause ?

Can you rewrite the sample query ?

anakin

David Burrows SSC Guru Points: 65142 More actions · Answer 3

Seems find except for table name

i.e.

select fullname

from (select Name + Surname as Fullname from tablea) as a

where Fullname > 'Paul'

order by Fullname

Far away is close at hand in the images of elsewhere.
Anon.

Simon Sabin SSCrazy Eights Points: 8142 More actions · Answer 4

What version of SQL are you using?

Simon Sabin

Co-author of SQL Server 2000 XML Distilled