title: How to get records by using 3 tables or work with 3 tables?
body: <p>I have been asked this question in an interview. I have tried so hard, but unfortunately was not able to get it right.can anybody help me with this?  </p>
  
  <p><strong>Retrieve the last name, first name, dept name of that employee using these tables.I am writing down the tables and columns.however, i am not writing that dummy data.</strong>   </p>
  
  <p>Employee- (id, last name, first name, DOB, SSN) and some other columns(not useful).<br>
  Dept - (D_id, dept name)<br>
  Emp_Dept - (id, D_id)   </p>