title: List the department names of all the employees working on a project
body: <p>I am working with a mysql DB called company with Tables:</p>
  
  <pre><code>Employee-&gt; |id_emp|fName|lName|id_Dept|
  
  Department-&gt; |id_Dept|dName|
  
  Project-&gt; |id_Proj|pName|id_Dept|status|budget|actBudget|
  
  Emp_Proj-&gt; |id_Emp|id_Proj|
  </code></pre>
  
  <p>I am still having a problem with how to run queries that work with the emp_proj join table. </p>
  
  <p>The question is "List the dept names of all the employees working on a project.</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT d.dName
  FROM department d
  JOIN ?????
  WHERE id_Emp = id_Proj ???
  </code></pre>
  
  <p>I'm not sure what to join b/c each employee has an id_Dept, and each employee working (or not working) on a project is shown in table emp_proj, so i'm not sure how to SELECT id_Emp working on a project and then compare that with the employee table to reference their id_Dept, and then output those dNames (dept names).</p>
  
  <p>Can anyone help with this type of Query syntax?  Tnx</p>