My question here is that I wish to calculate the grades achieved by a user based on his marks. I have 3 tables MARKS, GRADES and RESULTS. Their table structure is such:

MARKS: ID, Marks_obtained

GRADES: ID, GradeA, GradeB..... GradeE (these fields contain the LOWER LIMIT of it's respective grade)

RESULTS: ID, Grade_achieved, Marks_obtained.......

SO when MARKS.ID = GRADES.ID, compare the values of marks_obtained with each Grade and insert this value into RESULTS.Grade_achieved, and other values of ID and Marks_obtained....

Thanks in advance. :)

Can you show us sample data + desired result? BTW what version are