[Error message]

SELECT day, month, year,

winning_country.country_name winning_country,

losing_country.country_name losing_country,

matches.winning_score, matches.losing_score, location, crowd, worldcup, (matches.winning_score + matches.losing_score) as totalpoints

FROM matches,

countries winning_country,

countries losing_country

WHERE (matches.winning_country = winning_country.country_id)

AND (matches.losing_country = losing_country.country_id)

AND (totalpoints>50)

 

When I run this query, I get an error saying column totalpoints does not exist. Why is that?

[Query question]

I have a table with three records - player_id, year, and points.

 

Is there a way to compute a total points from point values stored in different records, in the initial query. Or do I need to execute a different query for every player, or add a total record for each player (call year 0000), and update both each time?

 

Example records.

 

player_id year points

 

1 2000 424

1 2001 313

2 2001 131

1 2002 242

2 2002 431

 

I want to return the total points for every player on the database. The number of years involved is a lot, so having all the years in the one record isn\'t really possible.

 

thanks