Re: count of a certain value in two columns
Posted by:
Khaba
Date: July 16, 2005 09:39AM
CREATE TABLE `scorelist` (
`T_id` int(11) NOT NULL auto_increment,
`player` int(11) NOT NULL default '0',
`a1` int(11) default NULL,
`a2` int(11) default NULL,
PRIMARY KEY (`T_id`)
);
In this table i will manage a player statistics. The field player manages the id of every player in my database. Every time a player scores 1 point there are two players called assistman. Now at the end of a season (or during) I want to find out how many assists a player got from every other player. So one player can be the scorer, the assistman 1 or the assistman 2. It can be happens that a player can be assistman1 or assistman2 for a score.
Subject
Written By
Posted
Re: count of a certain value in two columns
July 16, 2005 09:39AM
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.