Here's the results from SQL Server. These are the correct results:


Shot at 2008-05-29


Here's the results from Oracle. Notice how there's extra data that's not correct.


Shot at 2008-05-29

So how can I hone the query to get the same results?