ERROR: syntax error at or near "group" - Mailing list pgsql-admin

select sum(alq.quantity + alq.locked), category.id, alq.assetStatus.name

from AssetLocationQuantity alq inner join alq.asset asset inner join asset.assetModel model inner join model.category category

group by category, alq.assetStatus.name;

Error :

ERROR:  syntax error at or near "group"

LINE 3: group by category, alq.assetStatus.name;

        ^

********** Error **********

ERROR: syntax error at or near "group"

SQL state: 42601

Character: 201

Warmest Regards,

Premila Devi Dayalan Ramasamy
Programmer Analyst
MSAP Production Development

AGB Nielsen Media Research
Level 7,Block B,Menara PKNS-PJ,Jalan Yong Shook Lin , 46050 Petaling Jaya , Selangor
( Malaysia )

t: 603-7620 2320
f: 603-7620 2316

Please note:
This email transmission including its attachments, are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any views or opinions are solely those of the author and do not necessarily represent those of AGB Nielsen Media Research, unless specifically stated. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this email in error, please contact the sender and delete the email transmission immediately.