From: | Bernie Huang <bernie(dot)huang(at)ec(dot)gc(dot)ca> |
---|---|
To: | PGSQL-SQL <pgsql-sql(at)postgresql(dot)org> |
Subject: | Group by within table joins |
Date: | 2000-09-13 22:54:15 |
Message-ID: | 39C00596.C3F3EA89@ec.gc.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
Attachment | Content-Type | Size |
---|---|---|
bernie.huang.vcf | text/x-vcard | 315 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2000-09-13 23:19:33 | Re: Group by within table joins |
Previous Message | Tom Lane | 2000-09-13 20:48:36 | Re: Optimizing Multiply Joins ??? |