I am running a query and for some reason it leaves out one record each time. Not only that, but it is a different record each time I run it. I have verified this by comparing the results with a query from Hyperion’s Brio. I have posted some screen shots in the photo section. The Brio query is correct with the total sum that I am looking for and has 11564 records. Every time I run the Toad query, it only gives 11563 records and the sum is different every time, so I assume it is leaving out a different record each time. I have posted a shot of the two different SQL statements to show that they are the same. What could be causing this?