Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Conditions (SQL 6.5)
Message
From
21/09/1999 14:49:08
Dave Sonier
Technologies Nter inc.
Gatineau, Quebec, Canada
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
SQL Conditions (SQL 6.5)
Miscellaneous
Thread ID:
00267277
Message ID:
00267277
Views:
54
Hi,

Somebody knows if it is possible to do a condition with an alias column ???

Here's a sample:

select A_NO_AN = BDD.NO_AN from budg_dem_det bdd where A_NO_AN = 1999

I got this error message:
Msg 207, Level 16, State 2
Invalid column name 'A_NO_AN'.
Next
Reply
Map
View

Click here to load this message in the networking platform