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.
