By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,041 Members | 1,734 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,041 IT Pros & Developers. It's quick & easy.

Find maximum of two fields and then report that value to antoher

P: 6
I need to update a field in a table called "results" with the maximum number from one of two fields (say, "RAW and RAW_RG") in another table called "calcualtion".

The data in the "calcualtion" table is generated by a different software product.

My ultimate goal, is that i may run the calcualtion repeatedly, and each time I want to determine the max value for each entry in table and then createa a new table which only contains the maximum result.

thanks
Feb 13 '14 #1
Share this Question
Share on Google+
1 Reply


100+
P: 294
So the Maximum number to be returned can come from either "RAW" or "RAW_RG" ? And those are two separate fields in a database?
Feb 14 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.