Leonard_Banks
-
Posts
1 -
Joined
-
Last visited
Never
Leonard_Banks's Achievements
Newbie (1/5)
0
Reputation
-
I have 2 tables: Game -game_id -venue_id -season_id Points -point_id -game_id -player_id This query gets me what I want but it takes ~60 seconds. SELECT sum( P.points ) from Points as P, Game as G where G.season_id='8' and P.game_id=G.game_id and G.venue_id in ( SELECT distinct G.venue_id from Points as P, Game as G where G.season_id='8' and P.player_id = '8963' and P.game_id=G.game_id ) What this accomplishes is gives me the total points at the venues where the player has played. Anyone have any better options for this?