[grinch12]

I can get this to work right up until I try to sum the columns. Help!
select `vwcummstats`.`Position` AS `Position`,
`vwcummstats`.`Player` AS `Player`,
`vwcummstats`.`NHLTeam` AS `NHLTeam`,
`vwcummstats`.`Salary` AS `Salary`,
`vwcummstats`.`GP` AS `GP`,
(`vwcummstats`.`GLS` * `ssfhl4_ssfhl`.`tblpointvalues`.`GLS`) AS `GLS`,
(`vwcummstats`.`AST` * `ssfhl4_ssfhl`.`tblpointvalues`.`AST`) AS `AST`,
(`vwcummstats`.`PIM` * `ssfhl4_ssfhl`.`tblpointvalues`.`PIM`) AS `PIM`,
(`vwcummstats`.`PM` * `ssfhl4_ssfhl`.`tblpointvalues`.`PM`) AS `PM`,
(`vwcummstats`.`SHT` * `ssfhl4_ssfhl`.`tblpointvalues`.`SHT`) AS `SHT`,
(`vwcummstats`.`PPG` * `ssfhl4_ssfhl`.`tblpointvalues`.`PPG`) AS `PPG`,
(`vwcummstats`.`SHG` * `ssfhl4_ssfhl`.`tblpointvalues`.`SHG`) AS `SHG`,
(`vwcummstats`.`GWG` * `ssfhl4_ssfhl`.`tblpointvalues`.`GWG`) AS `GWG`,
(`vwcummstats`.`W` * `ssfhl4_ssfhl`.`tblpointvalues`.`W`) AS `W`,
(`vwcummstats`.`L` * `ssfhl4_ssfhl`.`tblpointvalues`.`L`) AS `L`,
(`vwcummstats`.`OTL` * `ssfhl4_ssfhl`.`tblpointvalues`.`OTL`) AS `OTL`,
(`vwcummstats`.`GA` * `ssfhl4_ssfhl`.`tblpointvalues`.`GA`) AS `GA`,
(`vwcummstats`.`SVS` * `ssfhl4_ssfhl`.`tblpointvalues`.`SVS`) AS `SVS`,
(`vwcummstats`.`SO` * `ssfhl4_ssfhl`.`tblpointvalues`.`SO`) AS `SO`,
`vwcummstats`.`FanTeam` AS `FanTeam`,
`vwcummstats`.`AcquireID` AS `AcquireID`,
`vwcummstats`.`PlayerID` AS `PlayerID`,
`vwcummstats`.`WeekNo` AS `WeekNo`,
sum(_utf8'(GLS)+(AST)+(PIM)+(PM)+(SHT)+(PPG)+(SHG)+(GWG)+(W)+(L)+(OTL)+(GA) +(SVS)+(SO)') AS `TTL
from (`ssfhl4_ssfhl`.`tblpointvalues` join `ssfhl4_ssfhl`.`vwcummstats` on((`ssfhl4_ssfhl`.`tblpointvalues`.`Pos` = `vwcummstats`.`Position`))
group by `vwcummstats`.`Position`,
`vwcummstats`.`Player`,
`vwcummstats`.`NHLTeam`,
`vwcummstats`.`Salary`,
`vwcummstats`.`FanTeam`,
`vwcummstats`.`AcquireID`,
`vwcummstats`.`PlayerID`,
`vwcummstats`.`WeekNo`,
`vwcummstats`.`GP`

[ehymel]

Are you getting an error message? That wold help narrow the problem down.

I do notice that at the end of the sum line you have

AS `TTL

but you should probably end the line with a close quote, as in

AS `TTL`

.