mysql query to fetch these results : <p>i have three tables<br>
1.<strong>project_ref_table</strong> with columns<br>
project_id(pk)<br>
project_name<br>
client_id(fk)<br>
project_description   </p>

<p>and 2.<strong>client_ref_table</strong> with column<br>
client_id(pk)<br>
client_name<br>
client_email<br>
client_address  </p>

<p>3.<strong>emp_ref_table</strong><br>
emp_id(pk)
emp_name<br>
emp_address<br>
project_id(fk)<br>
dept_id<br>
<strong>Suppose user who login with his emp_id is a manager and i need to fetch his client list with their project like this</strong></p>

<p><strong>client_name|client_email|client_address|project_name</strong></p>
