/*
Select
	*
	, (select staffname from mstaff where staffid=mtid) as mtname
	, (select staffname from mstaff where staffid=fcid) as fcname
	, (select staffname from mstaff where staffid=prid) as prname
	, (select staffname from staff where staffid=qcid) as qcname
	,c.divby
	,c.chartype
from
	Table_Rows j
	, Table_Client c
where
	j.clientid=c.clientid
	and j.fmflag ='P'
	and j.fmid='" & UserId & "'
	and j.clientid='1'
*/

SELECT
	-- DON'T USE * specify the columns you want back explicitly. 
	mt.[staffname] AS [mtname]
	, fc.[staffname] AS [fcname]
	, pr.[staffname] as [prname]
	, s.[staffname] AS [qcname]
	, c.[divby]
	, c.[chartType]
FROM
	Table_Rows j
	JOIN Table_Client c ON c.[clientID] = j.[clientID]

	LEFT JOIN mstaff mt ON mt.[staffId] = j.[mtid] -- This is a guess (I have no idea where mtid is)
	LEFT JOIN mstaff fc ON fc.[staffId] = j.[fcid] -- This is a guess (I have no idea where fcid is)
	LEFT JOIN mstaff pr ON pr.[staffId] = j.[prid] -- This is a guess (I have no idea where prid is)

	LEFT JOIN staff s ON s.[staffId] = j.[qcid] -- This is a guess (I have no idea where qcid is)
WHERE
	j.[fmflag] = 'P'
	AND j.[fmid] = '" & UserId & "'
	AND j.[clientID] = '1'