I'll simplify this a little:
You have two tables: comp_solved and EmployeeList and you need to get information from comp_solved plus the employee name from the related EmployeeList.
So try the basics first:
SELECT c.ComNo, e.EmployeeName
FROM comp_solved c
JOIN EmployeeList e ON c.[From] = e.ID
Run that, and you will get each ComNo with it's related EmployeeName.
Feed that back into your query, and it should be pretty obvious what you need to do