[Solved] SQL Selecting from three tables

Q1) Display the employee_name, Project_IDs and staff cost for all
employees

Should be like this:

SELECT e.Emp_name, pa.PROJECT_ID, pa.STAFF_COST
FROM Emlpoyee e
JOIN Pallocation pa 
   ON e.Emp_id = pa.Emp_id