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,
>
Mr. Huang,
Seems to me that your GROUP BY line should read:
GROUP BY ltb.v_id, vtb.equip_attr[1], vtb.equip_attr[3],
vtb.equip_attr[4]
Or am I missing the point?
-Josh
> SELECT ltb.v_id,
>count(ltb.v_id) AS num_of_times_borrowed,
>vtb.equip_attr
