yo,
SELECT Summe1.ID
FROM
(select r2.FK_id as ID, sum(r2.ranking) as Ranking
from ranking r2
group by r2.FK_id) Summe1,
(select r3.FK_id as ID, sum(r3.ranking) as Ranking
from ranking r3
group by r3.FK_id) Summe2
WHERE Max(Summe1.Ranking) = Max(Summe2.Ranking);
ersten wills du sicher nicht das kreuzprodukt beider tabellen (unterabfragen), sondern eher ein UNION ALL und selbst das scheint mir überflüssig zu sein.
SELECT r1.id
FROM raking r1
WHERE (SELECT SUM(r2.raking) FROM raking r2 WHERE r1.id = r2.id)
=
(SELECT MAX(tab1.summen)
FROM (SELECT sum(r3.ranking) as Summen FROM ranking r3 GROUP BY r3.FK_id
) tab1
)
Ilja