SQL Command - CR XI

I have an SQL Command which joins multiple tables and finds the effective recruiter using an embedded select statement.  I would like to look up that recruiter code in another table to get their actual name (last and first).  Would this be done as part of the SQL Command or directly through the report writer?  (See SQL Command attached)

The actual name resides in the tbl_employee table where the recrutier_code is tbl_employee.code.

select collection_Code, 
           collection_date, 
           gl.group_location_id, 
           cgr.projected_donors, 
           cgr.scheduled_donors,
	    recruiter_code = (select Top (1) recruiter_code from group_location_recruiter 
						where group_location_id = gl.group_location_id and 
                                                effective_date <= cg.collection_date order by effective_date DESC),
           cv.vehicle_code
	from collection_General cg Join collection_groups cgr 
	on cg.collection_id = cgr.collection_id
        Join collection_vehicles cv on cg.collection_id = cv.collection_id
	Join group_location gl on gl.group_location_id = cgr.group_location_id
Order By collection_code

Select allOpen in new window