At 09:49 PM 8/12/2004 +0000, you wrote:

> >
> > smels like there are null values somewhere...
> > Alan
>
>All of my fields in the database are defined using domains with NOT NULL.

In any case, nulls are ignored in SUM().

Both results are correct. The "discrepancy" you observe isn't a
discrepancy, but a result of two different query specifications. The first
query picks up all of the records, the second is an exclusive join that
purposely excludes those records in the left table that don't have matches
in the right table.

All you have to do is decide which is the one you want...

./heLen