a guest Feb 20th, 2019 56 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select ProductName, OrderDetails.OrderID
  2. from Products inner join OrderDetails
  3. on OrderDetails.ProductID=Products.ProductID where
  4. OrderDetails.OrderID='10256'
  6. select P.ProductName, D.OrderID, Case When D.OrderID Is Null Then 'No Comprado' Else 'Comprado' End Estado
  7. from Products P
  8. left join OrderDetails D on D.ProductID=P.ProductID
  9. where D.OrderID='10256'
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand