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

David Bridges wrote:

> What I'm trying to get is the total of both,

Something like this perhaps?

SELECT horse_no, SUM(points)
FROM (
SELECT horse_no, points FROM places
UNION ALL
SELECT horse_no, points FROM champs
) AS t
GROUP BY horse_no;

--
felix
Please use BBCode to format your messages in this forum.