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