| 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 ??? |