title: I want to view many fields from 3 table to show them in same page and same query
body: <p><img src="https://i.stack.imgur.com/qYNwo.jpg" alt="enter image description here"></p>
  
  <p>Hi 
  I have this three table . and i have form to put the id_student then the view must be :
  the name + surname +father then 
  the subjects and the mark of each subjects 
  how i can do that ? </p>
  
  <p>i try this : </p>
  
  <pre><code>select students.name, grade.marks 
  from students 
  INNER JOIN grade ON students.id_students = grade.id_students 
  </code></pre>