I have the following employee table:

* Employee(Columns: Emp\_ID, First\_Name, Last\_Name, DOB)
* Department(Columns: Dept\_Name, Dept\_ID)
* Dept\_Emp(Columns: Emp\_ID, Dept\_ID)

Say I am given the employee ID of 1 and I want to find all of the employees who work in the same department as the employee with ID 1 and return their name from the Employee table. I am having trouble formulating the query for such a task.

I was thinking it would look start to look something like:

```
SELECT Dept_Emp.Emp_ID
FROM Dept_Emp d1, Dept_Emp d2
WHERE d1.Emp_ID = '1'
AND d1.Dept_ID = d2.Dept_ID;

```

On the inside of some nested query? But I am not sure, as queries get more complex I get more confused and I tend to overthink. Thank you for your time.