title: Complex MySQL queries with multiple tables
body: <p><strong>1. Student Table</strong></p>
  
  <p><a href="https://i.stack.imgur.com/E7Jz5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/E7Jz5.png" alt="Student Table"></a></p>
  
  <p><strong>2. Subject Table</strong></p>
  
  <p><a href="https://i.stack.imgur.com/DBwdf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DBwdf.png" alt="Subject Table"></a></p>
  
  <p><strong>3. Exam Table</strong></p>
  
  <p><a href="https://i.stack.imgur.com/hWyDG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hWyDG.png" alt="Exam Table"></a></p>
  
  <p><strong>4. Mark Table</strong></p>
  
  <p><a href="https://i.stack.imgur.com/BxSIs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BxSIs.png" alt="Mark Table"></a></p>
  
  <p><strong>5. Project Table</strong></p>
  
  <p><a href="https://i.stack.imgur.com/wYvlC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wYvlC.png" alt="Project Table"></a></p>
  
  <p><strong>6. Daily Mark Table</strong></p>
  
  <p><a href="https://i.stack.imgur.com/jzCDg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jzCDg.png" alt="daily Mark Table"></a></p>
  
  <p><strong>Result Table</strong></p>
  
  <p>Suppose i have <strong>subjectID</strong> and <strong>classID</strong> for search. Then below example result will be show using above database table :</p>
  
  <p><a href="https://i.stack.imgur.com/aS0zY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aS0zY.png" alt="result table"></a></p>
  
  <p>Exam could be 7th exam or 8th exam not fixed but daily and project is fixed. daily mark 6 column can be possible for each student and project mark 2 column can be possible for each student. </p>
  
  <p>Anyone can help to write the sql select query ? is it possible in sql joining ?</p>