Advertisement
Guest User

SQL

a guest
Jan 26th, 2020
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.33 KB | None | 0 0
  1. SELECT P.ProductName as [Name of the Product], SD.Quantity as [Quantity]
  2.     FROM Products as P
  3.         INNER JOIN SaleDetails as SD
  4.         ON P.ProductID = SD.ProductID
  5.     ORDER BY DESC  
  6.    
  7. SELECT e.FirstName, e.Surname, e.LastName, e.Title
  8.     FROM Employees as e
  9.     INNER JOIN Stores as s
  10.     ON e.StoreID = s.StoreID
  11.     WHERE s.StoreName = 'Глория'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement