3 ms·
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
by dangoldin 15y ago
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