Обсуждение: ERROR: syntax error at or near "group"

Поиск
Список
Период
Сортировка

ERROR: syntax error at or near "group"

От
"Premila Devi"
Дата:

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

 

 

http://cs.agbnmr.com/ci/autocomposition/logo_agb.jpg

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.

Вложения

Re: ERROR: syntax error at or near "group"

От
Suresh Borse
Дата:
Hi,

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

 

 

http://cs.agbnmr.com/ci/autocomposition/logo_agb.jpg

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
_________________________________________________________________________________________