Re:"I've isolated the bug to a database query"
by dangoldin on Wednesday November 09, 2011 @09:58PM
(#3218665)
I'm no expert in SQL (Especially the Oracle flavor) but why would the following not work?
SELECT * FROM Products.Category AS c , Products.Product AS p WHERE c.CategoryId = p.CategoryId (+) AND p.ProductId IS NULL AND p.ManufacturerID = 123
Let's modify the query slightly, to retrieve all categories are not represented by any products from a particular manufacturer. The standard syntax would look like this:
How will you express this in your notation? In particular, what differentiates the "p.ManufacturerID = 123" of the join criteria from the "p.ProductId IS NULL" of the filter criteria?