Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calculated fields in SQL
Message
From
13/02/2006 16:07:11
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Calculated fields in SQL
Miscellaneous
Thread ID:
01095969
Message ID:
01095969
Views:
57
Is it possible to create a calculated field inside of an SQL statement?

For example: Suppose we have the statement,
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
the result contains fields x1 and x2. We want to add an additional field (dx) based on dx = abs(x1-x2). Is this possible within the SQL?

Thanks
Next
Reply
Map
View

Click here to load this message in the networking platform