Viewing 2 posts - 1 through 2 (of 2 total)
It is you? who is wrong.
I tried this example and received FIVE records:-P
October 28, 2015 at 4:11 am
#1835968
It's impossible to use column alias in WHERE clause.
For example:
select t_id, price*amount as x from t where x>1
will give an error "Invalid column name 'x'."
I could not find in BOL...
April 30, 2006 at 4:12 am
#635050