--Millist toodet ei olnud ühtegi korda tellitud - Rel Algebra tehted + alampäring
SELECT * FROM Products
WHERE Productid IN (
SELECT ProductID FROM Products
EXCEPT
SELECT DIstinct ProductID FROM [Order Details])
--Millist toodet ei olnud ühtegi korda tellitud - LEFT JOIN
SELECT DISTINCT P.*
FROM Products P LEFT JOIN [Order Details] O ON O.ProductID=P.ProductID
WHERE O.ProductID IS NULL
--Millist toodet ei olnud ühtegi korda tellitud - alampäring
SELECT * FROM Products
WHERE Productid NOT IN (
SELECT DIstinct ProductID FROM [Order Details])
Toodet mi