title: 3 tables MySQL join with non-shared atributes
body: <p>I have three tables, with the following (hypothetical) columns:</p>
  
  <ul>
  <li><code>student(name_id,time,pers)</code></li>
  <li><code>job(name_id,work_id,salary)</code></li>
  <li><code>departament(work_id,project)</code></li>
  </ul>
  
  <p>Now let's say I want to request the value of "pers", contained in the table <code>student</code> that matches with a certain project from the table <code>department</code>. I see that I first have to join <code>department</code> with <code>job</code>, and then the result with <code>student</code> to finally select the column I am interested in; but I'm not really sure how to do it, and everything I've tried has failed.</p>
  
  <p>Could you guys give me any hint on how to solve this problem?</p>
  
  <p>Thanks.</p>