Ysgrifennodd Jason Pruim:
Okay, so I have been gooling all over trying to figure this out. I'm
sure it's easy enough to do, but I can't seem to find it.
All I want to do is figure out the difference between 2 fields. IE:
Field 1= 20
Field 2 =10
Difference between Field 1 & 2 is: 10
Any ideas?
Erm:
SELECT FIELD1,
FIELD2,
FIELD1 - FIELD2 AS DIFFERENCE
FROM TABLE
?
Peter
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
