$qryAll = "
SELECT 
	$tblcounselors.LastName, 
	$tblcounselors.FirstName, 
	$tblcounselors.Phone 

FROM 

	$tblneedcounsel 

LEFT JOIN 

	$tblcounselors USING (IDNUM) 

GROUP BY

	$tblneedcounsel.Badge	

ORDER BY 
	($tblneedcounsel.Badge), 
	($tblcounselors.LastName), 
	($tblcounselors.FirstName);
";