code_junkie

Using an Alias column in the where clause in ms-sql 2000

Nov 12th, 2011
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.11 KB | None | 0 0
  1. select *
  2. from
  3. (
  4. select a + b as aliased_column
  5. from table
  6. ) dt
  7. where dt.aliased_column = something.
Add Comment
Please, Sign In to add comment