Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Column Alias and HAVING clause
April 7, 2006, 5:01 pm
rate this thread
I am having problems with the HAVING clause. I know it can use aliases
but the alias I am using has a space in it, eg 'Device ID'
My querry looks like (simplified, devID is a calculation)
SELECT devID AS 'Device ID' FROM tblDevice HAVING 'Device ID' = '123'
and it does not work
but if I use
SELECT devID AS 'Device_ID' FROM tblDevice HAVING Device_ID = '123'
How can I use an alias that contains a space in the HAVING clause?
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum