In the last episode (Jul 22), Andy McHargue said:
> I have table with very similar values in one field,
>
> count word
> -
> 2 APPLE
> 6 APPLES
> 1 APPEL
>
> select *,sum(count) as total from table group by word will leave
> these rows separated.
>
> So I want to GROUP BY that field to
I have table with very similar values in one field,
count word
-
2 APPLE
6 APPLES
1 APPEL
select *,sum(count) as total from table group by word will leave these
rows separated.
So I want to GROUP BY that field to add the numbers (to come up with 9
APPLES). Is this possible? I gues
