referance to a Calculate field in SQL Server

Thread View: comp.databases.ms-sqlserver

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Yoni Almog Wed, 23 Aug 2000 00:00

#108

Author: Yoni Almog
Date: Wed, 23 Aug 2000 00:00

15 lines
1374 bytes

I have a table with one field: mark.
I would like to create a quary with 2 calculated fields that the second is
based on the first.

SELECT Mark,
   Mark * 3 + 1 AS EXPR1, EXPR1  * 2  AS EXPR2
FROM Students

This code does not work on SQL Server.
It says: "Invalid coloum name EXPR1"
How can i refer to EXPR1 in this quary?
Thanks

mail me to:
ya94@hotmail.com

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads