unplugged_web Posted March 5, 2009 Share Posted March 5, 2009 how do I subtract one field from another? For example, if table a has 20 as it's entry and table b has an entry of 9 how do I dynamically display the results?Thanks Link to comment Share on other sites More sharing options...
justsomeguy Posted March 5, 2009 Share Posted March 5, 2009 You can use subtraction in a select statement, it's just the normal hyphen operator.e.g. SELECT 5 - 2 AS num Link to comment Share on other sites More sharing options...
unplugged_web Posted March 5, 2009 Author Share Posted March 5, 2009 You can use subtraction in a select statement, it's just the normal hyphen operator.e.g. SELECT 5 - 2 AS numthanks Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.