Any help would be really appreciated ?
-- Forwarded message --
From: Tompkins Neil neil.tompk...@googlemail.com
Date: Wed, Sep 8, 2010 at 5:30 PM
Subject: Query SUM help
To: [MySQL] mysql@lists.mysql.com
Hi
I've the following query :
SELECT total_team_rating, my_teams_id
Subject: Query SUM help
To: [MySQL] mysql@lists.mysql.com
Hi
I've the following query :
SELECT total_team_rating, my_teams_id
FROM
(SELECT players.teams_id AS my_teams_id, SUM(players_master.rating) AS
total_team_rating
FROM players
INNER JOIN players_master ON players.players_id
PM, Tompkins Neil
neil.tompk...@googlemail.com wrote:
Any help would be really appreciated ?
-- Forwarded message --
From: Tompkins Neil neil.tompk...@googlemail.com
Date: Wed, Sep 8, 2010 at 5:30 PM
Subject: Query SUM help
To: [MySQL] mysql@lists.mysql.com
Hi
I've
help would be really appreciated ?
-- Forwarded message --
From: Tompkins Neil neil.tompk...@googlemail.com
Date: Wed, Sep 8, 2010 at 5:30 PM
Subject: Query SUM help
To: [MySQL] mysql@lists.mysql.com
Hi
I've the following query :
SELECT total_team_rating, my_teams_id
On 9/9/2010 3:57 AM, Tompkins Neil wrote:
Any help would be really appreciated ?
-- Forwarded message --
From: Tompkins Neil neil.tompk...@googlemail.com
Date: Wed, Sep 8, 2010 at 5:30 PM
Subject: Query SUM help
To: [MySQL] mysql@lists.mysql.com
Hi
I've the following query
order by players.teams_id, players_master.rating desc) s1
where rank = 11
group by teams_id;
-Travis
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Thursday, September 09, 2010 1:58 AM
To: [MySQL]
Subject: Fwd: Query SUM help
Any help would be really
Hi
I've the following query :
SELECT total_team_rating, my_teams_id
FROM
(SELECT players.teams_id AS my_teams_id, SUM(players_master.rating) AS
total_team_rating
FROM players
INNER JOIN players_master ON players.players_id = players_master.players_id
WHERE players.worlds_id = 1 AND