Ahhh, capito e localizzato:

SELECT fp.project_id,fp.project_staff_lead,fp.project_title ,fp.project_status,CONCAT(fc.client_fname,' ',fc.client_lname) AS client_name
FROM fs_projects fp

Grazie, siete stati utilissimi.