Advertisement
yatahaze

PavloSheichenko

Mar 4th, 2023
856
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.18 KB | None | 0 0
  1. SELECT s.SupplierName, c.CategoryName, p.ProductName, max(Price)
  2. FROM Suppliers s
  3. JOIN Products p ON p.SupplierID = s.SupplierID
  4. JOIN Categories c ON p.CategoryID = c.CategoryID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement