MySQL Forums :: Transactions :: Help Needed With Query - Join?

Just use a UNION:

(
SELECT horse_no, rider_no, SUM(points) AS total
FROM places
WHERE season_no = 10
AND section_no = 12
GROUP BY horse_no, rider_no
)
UNION ALL
(
SELECT horse_no, person_no, SUM(points) AS total
FROM champs
WHERE season_no = 10
AND section_no = 12
GROUP BY horse_no, person_no
)
ORDER BY total DESC;

Also, be sure to put the proper GROUP BY in your queries. You were outputting horse_no, rider_no, but only grouping on horse_no. This produces unreliable results...

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com