Select TB_USERINFO.user_fname,TB_USERINFO.user_surname,Count(dbo.TB_FILEBORROWITEM.fileborrowitem_officerapprove) as total From dbo.TB_FILEBORROWITEM,TB_USERINFO Where dbo.TB_FILEBORROWITEM.fileborrowitem_officerapprove = TB_USERINFO.id_office Group by dbo.TB_USERINFO.user_fname,TB_USERINFO.user_surname