Advertisement
Guest User

Untitled

a guest
Nov 21st, 2014
164
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.19 KB | None | 0 0
  1. SELECT sname, spj.snum, spj.pnum, color, weight
  2. FROM spj, part, supplier
  3. WHERE spj.pnum = part.pnum
  4. AND spj.snum = supplier.snum
  5. GROUP BY snum
  6. HAVING weight = min(weight)
  7. AND color = 'blue'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement