You are viewing a single comment's thread. Return to all comments →
Using the operator is fine, I was wondering how does one get the grades column with the help of this join. How does the operator map to the grades variable selected at the start?
If person's 'marks' in Marks table falls under a perticular range between 'Min_Mark' and 'Max_Mark' of grades table then that perticular grade will be mapped in the resultset.
Didn't know JOINS can be used in this way too. In your usage,
you are getting a grade as ouput based on the condition on
Marks which is kind of new.