Indeed I do. I need to add another constraint on that query. It never would have occurred to me had I not asked. Problem solved. Thank you, thank you!
-Robin On Thu, 27 Sep 2001, Tom Lane wrote: > "Robin's PG-SQL List" <[EMAIL PROTECTED]> 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
