--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > Hi All,
> >
> > I'm using FB v1.5 and IBExpert v2004.08.05. I've found a situation
> > where the query result set seems really wierd.
> >
> > select sum(iu.QtySold * iu.ItemPrice), sum(iu.QtyUsed * iu.ItemPrice)
> > from xItemUsages iu
> > where iu.MinorID = 900033
> >
> > yields results of $2,538.6535 and $2,718.5150.
> >
> > However,
> >
> > select sum(iu.QtySold * iu.ItemPrice), sum(iu.QtyUsed * iu.ItemPrice)
> > from xItemUsages iu
> > join xLedgItem li on li.InvItemID = iu.InvItemID
> > where iu.MinorID = 900033
> >
> > yields results of $19,769.4608 and $21,230.3890.
> >
> > My original intent was to add the sum of a field in the xLedgItem
> > table but, when I added the join to that table, my result set when
> > crazy. As you can see, I have no ambiguous field references and all
> > the fields in both result sets are exactly the same. The only
> > difference is the join line.
> >
> > Where is this result coming from?
> >
> > Thanks for any help in understanding this,
> > Steve
>
> smels like there are null values somewhere...
> Alan

All of my fields in the database are defined using domains with NOT NULL.