ERROR: syntax error at or near "group"

This is a multi-part message in MIME format.

------=_NextPart_000_0026_01CA87DC.71A31AF0
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0027_01CA87DC.71A34200"

------=_NextPart_001_0027_01CA87DC.71A34200
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

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://www.agbnielsen.com/>
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.

------=_NextPart_001_0027_01CA87DC.71A34200
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">

<style>

</style>

</head>

<body lang=3DEN-MY link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

select
sum(alq.quantity + alq.locked), category.id, =
alq.assetStatus.name<o:p></o:p>

from
AssetLocationQuantity alq inner join alq.asset asset inner join
asset.assetModel model inner join model.category =
category<o:p></o:p>

group
by category, alq.assetStatus.name;<o:p></o:p>

<o:p> </o:p>

Error
:<o:p></o:p>

<o:p> </o:p>

ERROR:
syntax error at or near "group"<o:p></o:p>

LINE
3: group by category, alq.assetStatus.name;<o:p></o:p>


^<o:p></o:p>

<o:p> </o:p>

**********
Error **********<o:p></o:p>

<o:p> </o:p>

ERROR:
syntax error at or near "group"<o:p></o:p>

SQL
state: 42601<o:p></o:p>

Character:
201<o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

<a href=3D"http://www.agbnielsen.com/"><img
border=3D0 width=3D120 height=3D77 id=3D"_x0000_i1025"
src=3D"cid:image001.jpg [at] 01CA87DC.71713580"
alt=3D"http://cs.agbnmr.com/ci/autocomposition/logo_agb.jpg" ></a><=
span
style=3D'font-size:12.0pt;font-family:"Times New =
Roman","serif"'><o:p></o:p>

Warmest =
Regards,<o:p></o:p>

Premila Devi Dayalan =
Ramasamy 
Programmer =
Analyst 
MSAP =
Production
Development <o:p></o:p>

AGB Nielsen Media =
Research 
Level 7,Block B,Menara PKNS-PJ,Jalan Yong Shook Lin , 46050 Petaling =
Jaya ,
Selangor 
( Malaysia ) <o:p></o:p>

t: 603-7620 2320 
f: 603-7620 2316 =
<o:p></o:p>

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.<o:p></o:p>

</div>

</body>

</html>

------=_NextPart_001_0027_01CA87DC.71A34200--

------=_NextPart_000_0026_01CA87DC.71A31AF0
Content-Type: image/jpeg;
name="image001.jpg"
Content-Transfer-Encoding: base64
Content-ID: <image001.jpg [at] 01CA87DC.71713580>

/9j/4AAQSkZJRgABAgAAZABkAAD/7AARRHVja3kAAQAEAAAAZAAA/+4ADkFk b2JlAGTAAAAAAf/b
AIQAAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEB AQICAgICAgICAgIC
AwMDAwMDAwMDAwEBAQEBAQECAQECAgIBAgIDAwMDAwMDAwMDAwMDAwMDAwMD AwMDAwMDAwMDAwMD
AwMDAwMDAwMDAwMDAwMDAwMD/8AAEQgATQB4AwERAAIRAQMRAf/EAIMAAQAC AwEBAQAAAAAAAAAA
AAAHCAUGCQQDCgEBAAICAgMAAAAAAAAAAAAAAAUHBggCBAEDCRAAAQQDAQAB BAMBAQEAAAAABQME
BgcBAggACRESExQVFhciIyQRAAICAQMDBAICAwAAAAAAAAECAAMRBAUGIRIH MUEiE1EIMhRxgcH/
2gAMAwEAAhEDEQA/AP38eRHkR5EeRHkR5EeRHkR5EeRHkR5EeRHkR5EeRHkR 5EeRKJd79PSvmuuY
04gjJipMJ2edBRhYs0/fGAWg1j/IEX2zHKqWjwgprumm3TU+qX/W+++Nsafb trf+y3mDevEvFdJZ
xuus79uWpaqu2xe+ula077H7MgM5yqorfHqzEHtwcI51yXVcc2+ttCq/273K qzDIUAZJx7n0AB6e
pPpK+cA9sWreFhHautjcWec5jbyUAJKLDtQrtt/FvB7R8LKtR/4h67ZdMhqo gtokmppvptpv9+N9
c61f+sv7B808h8o1PDuamnU2/wBR9RTqK6lqZfrZFeuxUwhVg4ZGCgggq3d3 AiA4JzLdN63B9s3T
tsb6y6uqhSO0gFWA6EHOQcA+xznpXr51vk2urgOFUvD+e2gIdZN1vpg8Xn0n BJyNhEIxBtY9q7RC
BnucByMjNP5IjpjZ3qsi1bJKbZR33UT20+q3hDxts/PNbrNXv5dtt0S1j6kb sNj2d+O5h8gihD/H
BYkdQAc5fyXeNRtdddelwLrM/IjOAMeg9MnPv7e00T4J/lavLu0hcNMdINwp 6xKyj4WfALHjEcax
hoeihcsoBfBpOJGbaBmp4WTyhu0VaIoaO2qin3J43Qzup3vN/i3ZODppN446 XTb9TY1TUu5cq6r3
BkY/Ioy57gxJVgOuGwPVxre9TuZs0+rwbUAYMBjIJxgj0yD6Y9R/ifow9r3M sjyI8iPIjyI8iPIj
yI8iPIjyJB3RFOwG7KvPxewBGxJgwaupAJdNnCjImGNDGLrdoRGPkv8Atuvj TfdPfGcbJqpb7ab6
7Yz9PV15T4HxryFw7U7Pyeg26apGuqZWKWVW1oxWytx1U4ypHVWUlWBBkLyD aNDvW2WaXXp3IoLK
QcMrKDgqfY+34IJBnH3nilLLrqiat7C5z/dP2CkhLm9qVqQU/dYT2FtJYRYb so82SQ0ctSDJqGSV
yinvsqqrrhVL/vT8K2ivi3x9y7ivjjZvO3ir7NTydV1S7joHPems0i6l0KUK AGV0WpW7VJZmAdPk
vZZUuwbNuO3bJpuW8f7rNeBYLqT1FtYcjCjGQQFBwDknqOowbf3Nz3x18wXP sXbWSMMvWkbMqkw5
GPGNY3aFSTFVsk1PCk32Wz5Fv++2S1ScoOWzli/R0SVxpnbRLdP6ReBP2BXc 9qXmvj7UKFuT6tVp
rl7jXYvU06ivIIdGyUdSMg9yHtYiWZpdRs/MtsTUJkgHqM4et/dT+P8AYwww ZJ3Dfx3c0/HvD5NF
aAAnv3puRZkprOJsZ0kc3lCgxNwkHZECiLIYxbCA2jtb9Vo0at0E911N867K b7b5sPm3kDkfPtZX
qt+sr7KVIrrrXsrTOO4hcklmwO5mYk4AzgASW23atHtVbJpQcsepJyT+OvTo PYAS83sJklHkR5Ee
RHkR5EeRHkR5EeRHkTn58iHRUvoOqgLSCotkZFZBkhGsHnrRN+3BCWotR2VU btF8bNVSr5NXRJvl
XG6emv5N/s2zrr9NYv2l8qb7404ZpqOOKi7pu2oej7nUOtNa1lrCqn4mxwQq dwIA72wSBMD5/wAg
1exbXWmiAGo1LlO4jIVQuWwD07j6DPQdTiVI+LLoWYPTTrnIym1IRARFzUph 7tJqmgQArInG65ca
7cI664fjiTk9usnurjKqK2v2Y2203110pD9NfKO+37g/irXBLdio0duo0rBQ HpIuU21sw/mljXFg
W+SMO0EqwC4p4x3/AFb3Hj1wDaRKmes46phh3KT7glsjPUHpnB6fPuvJLkK1 wlpc8nitdSG8Rcnb
z4WPHjHcTIOgrgUvqdbDiTR2xQkDlcxtvvnCWfx7fcrp9uyyv5OH7Hf2/BvN dPzHxdqbtq3TkVOo
GtrRK20ztU1Z+5UsVkFzNaScL8Tl17TY/d45v9nE90Tc9gsbT361XFqgKUJU r8gCCAxLfjp1Ixk5
nL45esrLvVedQC03WsjMxMaOkYiXpDWg5dwMfvVR7kSa0GoNRyjtBzjRRqpo knuollTG/wB2U8be
sX9VPNnLvI9m5cZ5k41ev0VNd9WqFaozVu5RqrRWFQsGw1bBVLL3hs9uZNeP eU7lvbX6Dcz9ltSh
1swASCcFWxgZBwVOBkZz6TqZ7cqWdHkR5EeRHkR5EeRHkR5EeRHkSLbhpqAX tCXkBscRsVBOnDd6
go3cbsigok0zt+sUEEUf/Zg/R1U30+/X642T3202xtpttrnDed8C4z5I4/Zx rldBu253V1KsUsrs
XPbZU46o4BIyPVSykFSQYzd9n0G+aI6HcE7qCQRg4ZSPRlPsf+Eg9DI/oDlG nebMHVq4FE8lpHqg
iVkEiJ5Mm1WDbb8iAtB1lBsk0G6L/wDplJJPTCin023ztnXX6Yx4y8K8E8TD U2cUpuOt1YAsuvs+
20ovUVhsKFrB+RVVHc3VskDHQ2Hi20cd7ztyt9tmO5nPc2B6KDgYGeuAOp9f abRefP8AWfREVbxK
yxC71owfakw5QY72GnQj7Gn4lVxRNPRTZDDpvnKaye2u6S2n0+/TOddc6zPk bxjxHynsq7Jy2hrK
KrPsqsrb67qn9Ca7ADjuX4upBVh/JSQCOzvew7byDSjS7ihZVbKsDhlP5U+2 R0I6gj1HpPHQ3OVW
84x4lHq0FPG2pp9oQNmDD7YqeLro6bJNNHxHZNH6tWCSm2qCKeiaSf375xr9 2+2c9fxr4p4b4o2u
3a+JU2KNRYHuttf7LrSBhQ74HxQEhFACrliBliTx2Pj22ce07afblI72yzMe 5mPtk/gewGAMn8mT
t6yJNx5EeRHkR5EeRHkR5E5ffIv8gco4kKUa2h9ToWqLPlzFk9Hk1DCo/ek+ RK5OQeNW7cjdo302
yVOAjFmhsD2S26KLtPR39Ns7I/b5E2K8Onui5D0y+5H4yjFFkJ1AKWi18XZa nQJuZ719BY7Y8mls
VqmEAYlWyWkklM1nLmAG3y6zggLYCRTNNf6vVXCbbCJW65vkE6+rVnxdApRU XNfN15dGz/o2BWE8
6Ltgo+oyM6c/RcpIh8zgE2h2wsqci1xsx6T0AmVbjCaDV7ok7apuE98ZRLS/ H117YnVoe/2FkRKt
0DFA3Y4qBvbdDyo1OeeLyb6QqJTJeVVLKD4oY/cYi72UqR88z+9+mPODHCOH amcbaJIkQ018kckm
XYXV/MNk1qAhQSuZbYcW5gsIecIPEbrN0nXNfz26INJWTtsmlH57FBVmCCzN u2UV0JgVXS6euuw5
15EyVP8AyWw82FCTi8JNV9YxLHx28ydvzkIza2SRmEP3volKxO7dN5tHVorJ I0QMx/UVHxwxy7lL
4pjZLdl/9DP8yJsFnfJVBRdFXBYlaxGatLQpw5QTaT0vftdWDSE7YRa+Lei9 bRqbOYnMwgaRKxcy
0IlFBz5BJRuoQEuGa2U3DdwimiTER7856HXMQpTG1plCIOywFKymxwFL2efo +G3JKGgR6Cq+W3EI
jDuCgZY8Tk4xNTVd3q1ZuSLZu6XRXW0TyifBD5CeaHNvJ1A3NTtZRa1N6HQt VGqrEW5/WvdNTdqp
TKd6JR3etc2FoW02F5aZIYSydxkRhXJTGWfkTT69+UXkC0LAh1fRCU2C7zPb RmtFxefP6ZtYPUT+
9a/fS5lJKW3tUpEmsHZ2YknBibhAas803dIoa/i23UVST3ROhnkR5EeRHkR5 E5KdDfGez7NvTpma
9Az+zonXk8oeMcr1pH6WteRQfQ9TZILIJHa3+piBKTZqeWkljTdw3TZrqLIZ Ghm22ftyspr5EqqA
4q7hqSNw2w3dL89day61+Maw4c7p56mVwmq2E2ow58J2IDqe+4Tar+CzMYur MobPX39sjZMOhumk
8Tw0eKrNd9XKJXuBfFH1hRAHmt2w5x5A6EaUz2J2/eRPnEjY76DUeIr7qOtR YOCRmAv5xU1nLYbV
McWXaoJPA+iq6DPVxrlDZfOiaJ1c+N/lS3eeSXVFhWdFKko0Z0pbccsaF8lU CeIyinufWkegASEH
HQmQOonXwolNraKh/wCckW4mPiRn7mdM6JrL5cOFUSJpx8dlqTusO3GQ6XRy ubymfb8o7K4wtRhs
tIP85mjek6sryKvZcMVbMdMjJZpHD8ckgzGXKTmNGV8Y22UU1wmiVYNfEv0d NYE7iRQzWEeIo/Fb
8bnM4dxiUS1YOt0pxJfkgvw0CLO44zDSkdVEmKthgzBwevqWTaul10W2FkE9 VESRleCL7t6pehT8
k5wpznm6rIR5ngsSHrdP3P05OH0KpzoyNXROVZldNgZRCM4gQVYuF4yCGx9J 02cfnWeu/vf/AKzR
Eydw8VdbP+x5FYVB17E6MUnt6VhaRrrenOtLkrmOnq/h5KDKS6J9IcKKsjtW 35bEjh8XIRrU3hZq
1fj3rJddZioxykoianRfxqXLSlhAqE3pSrLH5tifUB3ooN0hYfUvQbworDDF 4meig0GX5DBvhFfr
3nBrFKJID5GoR1jOyTFAyswWffkHbokwV5wFe0X5x44q4hmB6SqkPk8sLryw NmchdbjF6ulPQPTd
msdhDz+ER3Jy3aPW0J/K03SRTw51X0/NnCeu26J2w8iPIjyI8iPInDLpPqfp Ck/l0psQznTt1xat
VXNlWXbVWRcd3bB7J7Atzo2tqbuliYcMU5CgsPtKr43Gn6Oj3DXDE7+X8O2+ mdvIlegHyozyB9Xf
IF0LbUsPPuIKu5ieTTn+oW4+NC13z6pemJRyoVnLKRP249Xbe9LiihLQY4IP NWDQNuyXU+zTO+2E
SyTP5pIQDDXWynMRqCX2VXFZ1TYMDjPKnTUb6QhtmHrntYZQ0LqF1YicHr5G DWancciEDniLoe5Y
4Fk0yjdwugmvomiQ1073H1dVUn7E1vOMyKj2FSc6cDSqNRbnq5ITOGr07dna MyrCRzaE2XP6MavG
m5EUg0CHh5mJa5/THK/obabOUSGqJYzo35b2HMN0lIJZ0FpEFDxF2VjUWoR5 1pDHPVsnBWfI4jDR
dxRPmONwuSJawVtJJglumyMysPIHgho5faMdcaJILIkk/MHdszoPlGITKG2j Pab0N9X8jVzOJ/Vw
NCS2GHq2yL8hMPsrSHA1IfPnBGQPIeVdptU2oYg82W21wggop9uuUSh9W/I0 Qol92Pcgm5b8644K
58qmtg72a9LRCNU5bMZ7inFjBYuF5/jxWTVjQZ3aEH4lYEdJnismA5YxjL5q u3froLOW6CJPqvzQ
xOOV31OclcLp2ZTvmmqauubYbzN0wN6EqeSwezp5/mTt4ctwTWcZcV+rUks1 y4mGroC6ywj2dCzL
D9HbZNNE2Y58uwOC88vLpmsZ51NKym+K156oGT0x2hWtpc1XRNbNFrG0Xr2/ 1ItFX1RBK7DiSz2U
qSSLtlGbMZncfqTVXRRyie6NfLE2lVa3kbAwmhZHOOf7SrKC2BKI72BAVOQg cJtmOOJRGrqL9RSC
JRxdrDxrcc7FlBDWJv5U1kCaLNMasg40e4RNHjfzKOZjX4F/X3P0cue05L3G R4Qj8dpHoARNaokc
9d84lujIXYwK5ClfRbClYkQbZs2OrOgjUjHsYfKZavFWabZ2iWFrXuroS0Zy S/qnG/8AZqQg/Q7T
lW0rKiN2sy81CWmFfMYjb04h9WE66j6Us5/p2zXK4kideHQx92wYOSbYDukn oioiVt4W+QLpAvXX
IO3QtTaHoD0ned388R3olzZgnFhE7GiMivw/EyRqkg1eMgwysDgCo3QcaUSk e5TZRBu4cjEkXH5c
IndTyI8iUG6V+Pyt+oHPUC0zmMxC46d5fr7mkpvG/wCLav6/1q6b2rYsHtKE kXDRwu2n0cmNn4fs
1Fsbot3Qhqpprjb7s5RI3kfxRc/SsQ+iZk/OP6U74arjhluFHuRLMkKjFVzx 1ZEPtYafUGul8WkM
l+6BDRwuiu02fNdFlEVM7Ka7ImRO/HpJ7lqe2606v6wtO9nVjiYONjZ0DEoB TQyqjFXTVtZNd2nD
obERb8GvdoqfDWJN6feZXbvNh7dskwaM8KNlESNJx8Ur26gt7rdCdZWjath9 CwPmyvpfLm0HryER
6MBOYr7fXzDW1cwEIPXYx5oeNP1EC2jx4TXcKLKr6r6YyiggiYyx/iMazxK+ YQw6jseF0VfnSYjr
mTVpH4BWm0nWu1jasQt58lIbcdiFJZMasXlEQR/TAPE8Ohzb8TRMjsOat2Oi Jf3p7mwB1BEa7iMi
khuLtq66BoLoMe8BIMF3JA7QFpRu0wYB5qQSWTTEHiUaTau908YX0QU2yntr v9M+RIDur456zu2c
9KSktOZvFgvU9a0xG7HjESTjzPZhbXOkx2l1JdFRQ2QEknA+zIT+Fkz3SdIv RRJqHHaOmyibX8ai
JmY9yNdytf2mFsruS7pVZtgtIYwjtmwaKVpU46sEYAfVkgh9FqxDgDcMJm5m QVylM1y2r5CRjvox
0QYM9dEdUSt4L4iIfhjZUyl1yvlOlpxZNHXFGb1qioKspkVVtm83t5uyqmXR KoQoo5EzJJ0Isc4M
lW59cupJRBHdltu2RSa4bom72F8b8wtqEwV1ZvW9gTLoKrehIx0xWVoEq7gX +UQawIhBj1cBgAXm
zVPMP/zvMZk75yu1VJqHFD62CepZNVJHRNE90G+MmPxifArQk182jYs6Z9pj +55EckrCKof2O0ku
UynKZGMosRQ1ozjtd7xklq+Hjmemu4zZsk21VVTxvvuiZlj8ehKP3AekcI6j ueB8+zHonTrOZc3x
NIAGRMXooeGyw5q0uAe3a2MKpqczEUmYkUOwqs3KPlXCX7SI105HrIm1QrgC EQqreSasaT6WvhvI
3QJ3oOLlHLIIm+lp082u1ssAkCSDXRq1Doa3e8zps11TW+rJD65/6U+qJfzy I8iPIjyI8iPIjyI8
iPIjyI8iPIjyI8iPIjyJ/9k=

------=_NextPart_000_0026_01CA87DC.71A31AF0--

--=-swUmJbc1hZDDlistE6oc
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

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
____________________________________________________________ _____________________________

--=-swUmJbc1hZDDlistE6oc
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.14.1">
</HEAD>
<BODY LINK="#0000ff">
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:
<BLOCKQUOTE TYPE=CITE>
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 
 
 
 
 
 
<A HREF="http://www.agbnielsen.com/"><IMG SRC="cid:image001.jpg [at] 01CA87DC.71713580" WIDTH="120" HEIGHT="77" ALIGN="bottom" ALT="http://cs.agbnmr.com/ci/autocomposition/logo_agb.jpg" BORDER="0"></A> 
 
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. 
 
 
</BLOCKQUOTE>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
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 : <A HREF="http://www.direction.biz/">www.direction.biz</A> 
_________________________________________________________________________________________
</TD>
</TR>
</TABLE>
</BODY>
</HTML>

--=-swUmJbc1hZDDlistE6oc--

ERROR: syntax error at or near "group"

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