Hallo,
select sum(Punkte) from games where Name in (select Name from spieler)
hier fehlt noch was:
select sum(Punkte) from games where Name in (select Name from spieler) and games.name = spieler.name
so sollte es jetzt gehen.
Grüße
Andreas
--
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
(Rich Cook)
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
(Rich Cook)