SELECT supplier_parts.pno 
FROM   supplier_parts
WHERE  supplier_parts.sno = 'S1'
   OR  supplier_parts.pno IN
      (SELECT parts.pno
       FROM   parts
       WHERE  parts.pname = 'Screw')