Solved : Newbie question - Working with models

[eluser]ywftdg[/eluser]
What sort of confuses me here is why is the group necessary then, if we are only doing one select? For exmaple, if I remove the group it brings up the error:

Code:

Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

SELECT `pSku`, `pName`, `pCost`, `pPrice`, `pSkulist`, sum(`pPrice`) as BaseBundlePrice FROM (`products`) WHERE `pSkulist` <> ''