On 8 Apr 2002, at 18:18, Ari B Kahn wrote:
> OK. Now notice that insFreq has DOUBLED when used in conjunction with
> with delFreq!
> mysql> select t1.andersonStart_pos, sum(t2.insFreq), sum(t1.delFreq)
> from InsertionFreq t2, DeletionFreq t1 where (t2.andersonStart_pos =
> 1072) and (t1.ande
I have MySQL v. 3.23
The SUM function seems to be doubling one of my values when used in
conjunction with another SUM function.
Here I show that I have only 95 in insFreq:
mysql> select t2.andersonStart_pos, sum(t2.insFreq) from InsertionFreq
t2 where t2.andersonStart_pos = 1072 group by t2.and
