Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calculated fields in SQL
Message
 
 
To
13/02/2006 16:12:23
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01095969
Message ID:
01095998
Views:
14
It's not going to work. You cannot reference calculated fields in consequent calculations in the same list. You can use derived table
SELECT *, ABS(dt1.x2-dt2.y2) AS dx ;
  FROM ( ;
select temp1.*,nodes.x as x2, nodes.y as y2, 
	from UPDNETATR!xydata nodes ;
	right outer join temp1 ;
	on  nodes.n = temp1.b;
	where st_name <> ' ' ;
	order by temp1.st_name ;
       ) dt1 
>Yes it is:
>BTW the result contains x2 and Y2 :-)
>of course if you didn't have X1 in Temp1
>
>select temp1.*,nodes.x as x2, nodes.y as y2, ABS(nodes.x-nodes.y) AS dx;
>	from UPDNETATR!xydata nodes ;
>	right outer join temp1 ;
>	on  nodes.n = temp1.b;
>	where st_name <> ' ' ;
>	order by temp1.st_name
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform