From: | Jie Liang <jliang(at)ipinc(dot)com> |
---|---|
To: | Bernie Huang <bernie(dot)huang(at)ec(dot)gc(dot)ca> |
Cc: | PGSQL-SQL <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Group by within table joins |
Date: | 2000-09-13 23:28:50 |
Message-ID: | 39C00DB1.F789190@ipinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)ipinc(dot)com
www.ipinc.com
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Quinlan | 2000-09-14 04:57:04 | Web Hosts (off-topic) |
Previous Message | Josh Berkus | 2000-09-13 23:19:33 | Re: Group by within table joins |