SQL query: How to join two different tables in one query : i have two tables grades and scholars.

grades has fields: id, subject_code, subject_description,midterm, final, and final_remarks

AND
scholars has fields:id, Id Number, Lastname,Firstname, Middlename ,School, Year, Semester, Course,Action

how can i join them? i wanna get the subject_code, subject_description,midterm, final, and final_remarks from grades and fullname from scholars?


THANK YOU!PLEASE HELP ME WITH THIS.