sql join from two different table values
===

There is two table name as "Department" and "Employee".The Department table has two column named as 'dept_id' and 'dept_name' and 'location' And the Employee table has two column named as 'emp_name' and 'emp_id' and 'age'.
My requirement is to show a result in a table bye below column from those table 
"dapt_name,location,emp_id"


(I have the image but I couldn't able to insert as because I am a new user)
