Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT sname, spj.snum, spj.pnum, color, weight
- FROM spj, part, supplier
- WHERE spj.pnum = part.pnum
- AND spj.snum = supplier.snum
- GROUP BY snum
- HAVING weight = min(weight)
- AND color = 'blue'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement