[SOLVED] Please Correct This Quiery

Dear sir,
I have used the below query to display the cb users,
but the name field is not displaying, so please help me out.
SELECT
C.cb_regnoyearofpassing,
C.cb_fathername,
C.cb_address,
C.cb_sdob,
C.cb_semisteryear,
C.cb_qualification,
C.cb_subject1,
C.cb_subject2,
C.cb_subject3,
C.cb_subject4,
C.cb_subject5,
C.cb_subject6,
C.cb_gender,
C.cb_category,
C.cb_totalfeeksou,
C.cb_branchname,
C.avatar,
C.user_id
FROM
#__comprofiler C INNER JOIN #__users U
ON C.user_id = U.id
INNER JOIN #__user_usergroup_map UM
ON U.id = UM.user_id
INNER JOIN #__usergroups UG
ON UM.group_id = UG.id
WHERE
U.block = 0
AND
UG.title = 'Client'

Thanking You

You're not selecting the name column, which is in _users. So you need to add U.name to your select.

Dear sir,
Thank you very much for your support and help,
it is worked fine,
Thanks,