Helen Borrie wrote:

> select A.PK, A.field2, A.fieldx,
> (select sum(B.Numberfield) from B
> where B.FK = A.FK
> and B.Numberfield is not null) AS BTotal
> from A

Is there any difference (speed, result...) between that and:

select A.PK, A.field2, A.fieldx, sum(B.Numberfield) AS BTotal
from A
left outer join B on B.FK = A.FK

?

--
Milan Babuskov
http://fbexport.sourceforge.net