Advertisement
Guest User

patryl

a guest
Apr 7th, 2019
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.24 KB | None | 0 0
  1. SELECT  p.ProductName,
  2.         MIN(p.UnitsInStock) AS 'Najmniejszy zapas',
  3.         s.CompanyName,
  4.         s.Phone
  5. FROM Products p
  6. LEFT JOIN Suppliers s
  7. ON p.SupplierID = s.SupplierID
  8. GROUP BY p.ProductName, s.CompanyName, s.Phone
  9. ORDER BY 'Najmniejszy zapas';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement