Re: Add points in many fields and one row
> M.Player9_id
Are there exactly 9 "players" in each row? Even if there are, that is not a good way to design a database. There should be 9 (or fewer) rows in a Players table, all JOINed to central table.
Or maybe that is what you did? But did the JOINing backwards.
Mitspieler M should NOT have the list of players; instead it should deduce them by JOINing to view_punkte_kombiniert.
Once you have redesigned the schema, a simple SUM(), possibly with a GROUP BY, will provide the answer.
Subject
Written By
Posted
Re: Add points in many fields and one row
May 31, 2014 05:30PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.