I have an Oracle database with a table with no duplicates, and a view on that table which appears to have some duplicates. I thought at first that the duplication was caused by a missing join, however, here's the strange part:
If I run both of these queries against the view, they both produce 7-10 results with no overlap. Now, okay, fine, 2 queries may not necessarily produce any overlap, however, the only difference between these 2 queries is that in the first query I've explicitely selected a handfull of skus. Those skus that I selected appear to be duplicated only if I select them, but not if I leave the where clause out completeley??? Either that or when I introduce the where clause Oracle then chooses to ignore the having clause. Or if I don't provide the where clause Oracle doesn't find all the instances of duplication. select sku from vweb_product where sku like '93/50%' group by sku having count(sku) > 1 order by sku; select sku from vweb_product group by sku having count(sku) > 1 order by sku; This makes no sense to me. Anybody have any suggestions? s. isaac dealey 954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
