Sql help

cpod500 · #1 (**permalink**) 08-11-11, 16:55

say i have a table with home points and away points columns for 10 teams, is there a command that will let me add the points together for each seperate team, and if possible creat a report from it, cheers

r937 · #2 (**permalink**) 08-11-11, 19:46

yes, there is, it's called the addition operator, and it is implemented in mysql by the plus sign

Code:

SELECT team
     , home_points + away_points AS total points
  FROM daTable

Internet Services

Web Development

Digital Marketing

Consumer Tech