Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
AS Clause
Message
From
28/08/2000 11:03:08
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
AS Clause
Miscellaneous
Thread ID:
00409807
Message ID:
00409807
Views:
60
Dear readers,

When i execute the folowing SQL query, i get the error colomn "WTG"not found.

SELECT detail.avr_ari,;
iif(Detail.avr_wtg=.t.,'J','N') as WTG;
FROM general!detail;
WHERE WTG='J'

Is this an impossible kind of query, to include an expressionalias in the WHERE Clause ?

Any idea's how to solve this ?

- Bjorn
Next
Reply
Map
View

Click here to load this message in the networking platform