All pastes #718905 Raw Edit

Stuff

public text v1 · immutable
#718905 ·published 2007-09-28 19:51 UTC
rendered paste body
$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);
";