X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 09AC6D1B526
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 28 Sep 2003 18:47:29 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 99961-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 28 Sep 2003 15:46:59 -0300 (ADT)
Received: from smtp-1.indo.net.id (smtp-1.indo.net.id [202.159.32.91])
	by svr1.postgresql.org (Postfix) with SMTP id BFED7D1B550
	for <pgsql-sql@postgresql.org>; Sun, 28 Sep 2003 15:46:54 -0300 (ADT)
Received: (qmail 32045 invoked from network); 29 Sep 2003 01:46:45 +0700
Received: from smtp.indo.net.id (202.159.32.81)
	by smtp-1.indo.net.id with SMTP; 29 Sep 2003 01:46:45 +0700
Received: (qmail 12131 invoked from network); 28 Sep 2003 18:44:31 -0000
Received: from unknown (HELO smtp) (202.159.51.117)
	by smtp.indo.net.id with SMTP; 28 Sep 2003 18:44:31 -0000
Received: FROM middinkcomp BY smtp ; Mon Sep 29 01:57:06 2003 +0700
Message-ID: <001401c385ea$836f5960$29179fca@middinkcomp>
From: "Muhyiddin A.M Hayat" <middink@indo.net.id>
To: <pgsql-sql@postgresql.org>
Subject: SUM() & GROUP BY
Date: Mon, 29 Sep 2003 02:01:14 +0800
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0010_01C3862D.900E1C40"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=2.0 tagged_above=0.0 required=5.0 tests=HTML_20_30,
	SUBJ_ALL_CAPS
X-Spam-Level: **
X-Archive-Number: 200309/363
X-Sequence-Number: 15341

This is a multi-part message in MIME format.

------=_NextPart_000_0010_01C3862D.900E1C40
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


hotel=3D# SELECT
hotel-#   "public".billing.id,
hotel-#   "public".billing.guest_id,
hotel-#   "public".billing.trx_date,
hotel-#   "public".billing.trx_time,
hotel-#   "public".billing.payment_method,
hotel-#   "public".billing.tax,
hotel-#   "public".billing.dep_id,
hotel-#   "public".department."name",
hotel-#   SUM("public".items.price) AS total,
hotel-#   "public".billing.amount_paid
hotel-# FROM
hotel-#   "public".billing_items
hotel-#   INNER JOIN "public".billing ON ("public".billing_items.billing_id=
 =3D "public".billing.id)
hotel-#   INNER JOIN "public".department ON ("public".billing.dep_id =3D "p=
ublic".department.id)
hotel-#   INNER JOIN "public".items ON ("public".billing_items.items_id =3D=
 "public".items.id)
hotel-# GROUP BY  "public".billing.id;
ERROR:  Attribute billing.guest_id must be GROUPed or used in an aggregate =
function
hotel=3D#

What Worng ??

How to using SUM() & GROUP BY
------=_NextPart_000_0010_01C3862D.900E1C40
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>hotel=3D# SELECT<BR>hotel-#&nbsp;&nbsp;=20
"public".billing.id,<BR>hotel-#&nbsp;&nbsp;=20
"public".billing.guest_id,<BR>hotel-#&nbsp;&nbsp;=20
"public".billing.trx_date,<BR>hotel-#&nbsp;&nbsp;=20
"public".billing.trx_time,<BR>hotel-#&nbsp;&nbsp;=20
"public".billing.payment_method,<BR>hotel-#&nbsp;&nbsp;=20
"public".billing.tax,<BR>hotel-#&nbsp;&nbsp;=20
"public".billing.dep_id,<BR>hotel-#&nbsp;&nbsp;=20
"public".department."name",<BR>hotel-#&nbsp;&nbsp; SUM("public".items.price=
) AS=20
total,<BR>hotel-#&nbsp;&nbsp; "public".billing.amount_paid<BR>hotel-#=20
FROM<BR>hotel-#&nbsp;&nbsp; "public".billing_items<BR>hotel-#&nbsp;&nbsp; I=
NNER=20
JOIN "public".billing ON ("public".billing_items.billing_id =3D=20
"public".billing.id)<BR>hotel-#&nbsp;&nbsp; INNER JOIN "public".department =
ON=20
("public".billing.dep_id =3D "public".department.id)<BR>hotel-#&nbsp;&nbsp;=
 INNER=20
JOIN "public".items ON ("public".billing_items.items_id =3D=20
"public".items.id)<BR>hotel-# GROUP BY&nbsp;=20
"public".billing.id;<BR>ERROR:&nbsp; Attribute billing.guest_id must be GRO=
UPed=20
or used in an aggregate function<BR>hotel=3D#</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>What Worng ??</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>How to using SUM() &amp; GROUP=20
BY</FONT></DIV></BODY></HTML>

------=_NextPart_000_0010_01C3862D.900E1C40--