Help Writing Query

I have a database that contains projects and information about the projects.

So, for example:

proj Table

Columns:
project_id
project_name
project_code

Sample Data:
project_id: 1
project_name: Test1
project_code: Alpha6


emp Table

Columns:
employee_id
employee_name

Sample Data:
employee_id: 1
employee_name: david

employee_id:2
employee_name: mike

employee_id:3
employee_name:jason


assign_emp Table

Columns:
project_id = project id from proj table
assign_lab = employee id from emp table
assign_tech = employee id from emp table
assign_tester = employee id from emp table

Sample Data:
project_id: 1
Assign_lab: 1
Assign_tech: 2
Assign_tester: 3



So, I have a table called "proj" that contains the "project_id", "project_name", "project_code" and other various information (not related to my current task). I then have a master employee table called "emp". This contains information about the employees, including the "employee_id" and "employee_name". I then have a 3rd table that links the employee to the project. I've called it: "assign_emp". This table contains the "project_id", "assign_lab", "assign_tech", "assign_tester".

I want to create a query to be able to list the following in a single row, For Example:

Project ID | Project Name | Project Code | Lab Employee | Tech Employee | Tester Employee

1 | Test1 | Alpha6 | david | mike | jason


My problem is figuring out how to select multiple employees from a single table based on whether they are assigned to the project or not. As far as I got was:

Select proj.project_id, proj.project_name, proj.project_code, emp.employee_name as 'Lab Employee' from proj inner join assign_emp on proj.project_id = assign_emp.project_id inner join emp on assign_emp.assign_lab = emp.employee_id where proj.project_id = 1



Any help figuring out the query would be great!