Обсуждение: ERROR: syntax error at or near "group"
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.
Вложения
what is "alq.assetStatus " and " alq.asset"? Is it a table name?
syntax for referring column is "tablename.columnname" .
We need to use column names in the group by clause.
I think you need to check query syntax and you have not used assetStatus table in the query.
On Mon, 2009-12-28 at 16:40 +0800, Premila Devi wrote:
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.
Thanks & Regards, Suresh Borse (DBA) _________________________________________________________________________________________ DIRECTION SOFTWARE SOLUTIONS 5, Brady Gladys Plaza, 1/447, Senapati Bapat Marg, Lower Parel, Mumbai - 400 013 Tel. : 91 22 66615000 (Ext: 270) Fax : 91 22 24911046 Cell : Site : www.direction.biz _________________________________________________________________________________________ |