SELECT product.Id,product.Name,product.Price,product.CategoryId
FROM product
LEFT JOIN orderdetails ON orderdetails.ProductId = product.Id
WHERE orderdetails.ProductId IS NULL;