SUM() & GROUP BY

From: "Muhyiddin A(dot)M Hayat" <middink(at)indo(dot)net(dot)id>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: SUM() & GROUP BY
Date: 2003-09-28 18:01:14
Message-ID: 001401c385ea$836f5960$29179fca@middinkcomp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


hotel=# 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 = "public".billing.id)
hotel-# INNER JOIN "public".department ON ("public".billing.dep_id = "public".department.id)
hotel-# INNER JOIN "public".items ON ("public".billing_items.items_id = "public".items.id)
hotel-# GROUP BY "public".billing.id;
ERROR: Attribute billing.guest_id must be GROUPed or used in an aggregate function
hotel=#

What Worng ??

How to using SUM() & GROUP BY

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-09-28 18:29:14 Re: Mystery function error
Previous Message Tom Lane 2003-09-28 16:48:10 Re: Mystery function error