"Robin's PG-SQL List" <pg-sql@mail.robin.net> writes:
> I have a query using the SUM() function that is not returning the
> appropriate results.
I'm guessing that you have two rows in bolcustomer matching
bol_number = 88738, so that the 14 gets added in twice.
regards, tom lane