Browse by Tags

All Tags » BUG (RSS)
Monday, March 19, 2007 3:37 PM

Bug Resolution

Q: A Select statement involving an inner join between two tables, one with an index on the join column and the other has no index, is returning incorrect results? A: There is a known issue which has been acknowledged in this knowledge base article
Posted by Administrator | with no comments
Filed under: , , , , ,
Saturday, February 10, 2007 11:39 PM

BUG: Aggregation

Q: I'm getting incorrect results when I run an aggregation query, such as the following: SELECT Orders.OrderDate, SUM(OrderLines.Quantity * OrderLines.QualityReference) AS Total FROM Orders inner join OrderLines on Orders.OrderNo = OrderLines.OrderNo...
Posted by Administrator | with no comments
Filed under: , ,
More Posts