SELECT product.Id,product.Name,product.Price,
product.CategoryId FROM product
EXCEPT
SELECT product.Id,product.name,product.Price, product.CategoryId
FROM product
INNER JOIN OrderDetails ON orderdetails.ProductId = product.id;