USE of ORDER BY in a JOIN select query

Databases
1

Hi, I have two tables, one has names, while the other has results (numeric, two decimals). The select query below works but I want to include ORDER BY r.total DESC.


$sql ="SELECT s.student_fname,s.student_sname,s.student_id, r.id, r.math,r.eng, r.total
FROM students s
	INNER JOIN results r ON (s.student_id = r.student_id) 
	LEFT JOIN results rl ON (r.student_id=rl.student_id AND r.id<rl.id)
WHERE rl.student_id IS NULL AND s.class_id=".$_GET['class_id'];
// I want to ORDER BY r.total
2

Hi, that worked. I was getting a parse error but then I had to replaced

".$_GET['class_id']

with

$class_id

Thank you.:cool:

3 
SELECT s.student_fname
     , s.student_sname
     , s.student_id
     , r.id
     , r.math
     , r.eng
     , r.total
  FROM students s
INNER 
  JOIN results r 
    ON r.student_id = s.student_id
LEFT OUTER
  JOIN results rl 
    ON rl.student_id = r.student_id
   AND rl.id > r.id
 WHERE rl.student_id IS NULL 
   AND s.class_id = ".$_GET['class_id']
[COLOR="Blue"]ORDER
    BY r.total DESC[/COLOR]

that was easy, wasn’t it :slight_smile: