You are viewing a single comment's thread. Return to all comments →
Simple version of the above code, since field names are different in each table, no need to put table names in query
select if(Grade < 8,NULL,Name),Grade,Marks from Students inner join Grades on Marks >= Min_Mark and Marks <= Max_Mark group by Grade desc,Name,Marks asc
The Report
You are viewing a single comment's thread. Return to all comments →
Simple version of the above code, since field names are different in each table, no need to put table names in query