Facebook
From ee, 1 Month ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 129
  1. SELECT product.Id,product.Name,product.Price,
  2. product.CategoryId FROM product
  3. EXCEPT
  4. SELECT product.Id,product.name,product.Price, product.CategoryId
  5. FROM product
  6. INNER JOIN OrderDetails ON orderdetails.ProductId = product.id;