Received: from tidal.ipinc.com (tidal.ipinc.com [199.245.188.85]) by hub.org (8.10.1/8.10.1) with ESMTP id e8DNWIs03668 for ; Wed, 13 Sep 2000 19:32:18 -0400 (EDT) Received: from ipinc.com (jliang.ipinc.com [199.245.188.130]) by tidal.ipinc.com (8.9.3/8.9.3) with ESMTP id QAA14409; Wed, 13 Sep 2000 16:31:40 -0700 (PDT) (envelope-from jliang@ipinc.com) Message-ID: <39C00DB1.F789190@ipinc.com> Date: Wed, 13 Sep 2000 16:28:50 -0700 From: Jie Liang Organization: ipinc.com X-Mailer: Mozilla 4.7 [en] (X11; U; FreeBSD 3.4-RELEASE i386) X-Accept-Language: en MIME-Version: 1.0 To: Bernie Huang CC: PGSQL-SQL Subject: Re: Group by within table joins References: <39C00596.C3F3EA89@ec.gc.ca> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200009/98 Hey, If you use group then except aggreate functions(count,sum..) other items in your select list should be in your group list also. Bernie Huang wrote: > Hi, I have the following SQL: > > SELECT ltb.v_id, > count(ltb.v_id) AS num_of_times_borrowed, > vtb.equip_attr[1] AS year, > vtb.equip_attr[3] AS model, > vtb.equip_attr[4] AS type > FROM log_tb ltb, vehicle_tb vtb > WHERE ltb.v_id=vtb.equip_id > GROUP BY ltb.v_id > ORDER BY year; > > "ERROR: Attribute vtb.equip_attr must be GROUPed or used in an aggregate > function" > > but, it didn't work. I want to know how many time each vehicle has been > borrowed. Please help. Thanks. > > - Bernie -- Jie LIANG Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 jliang@ipinc.com www.ipinc.com