I need to update a field in table pocalc from data from the same record
SET Pocalc.max =ceiling(SUM(slspd01+slspd02+slspd03+slspd04+slspd05+slspd06+slspd07+slspd08+slspd09+slspd10+slspd11+slspd12)/12)
WHERE (SiteID = 'west') AND (InvtID LIKE 'fri%')
I get the following error:
An aggregate may not appear in the set list of an UPDATE statement.
I was wondering if someone could point me in the right direction to reformatting this.