I have two tables
ID - Name - Mark 232 - Mike - 49 859 - Joanna -77 849 - Clark - 83
ID - Range - Score 1 - 50 - D 2 - 60 - C 3 - 70 - B 4 - 80 - A
I want the following results:
Mike - Fail Joanna - B Clarke - A
Ive tried the IN statement in where clause but if the Mark is not an exact match to Score it returns nothing. I want it to return within the band score range, like above, and any score < 50 = FAIL.