Select A.Key, sum(A.Val),Sum(B.Val)
FROM TEST1 A
INNER JOIN TEST2 B ON A.KEY=B.KEY
GROUP BY 1
HAVING sum(A.Val)= sum(B.Val)

---

 Comments

---

Problem was with the DBISAM engine locating the source table for the SUM aggregate functions properly, resulting in the same A.Val column being used for both SUM expressions in the HAVING clause.

---

 Resolution

---

Fixed Problem on 8/17/2001 in version 2.12 build 1