Select Code to Download

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

SELECT parts.pno
FROM   parts, supplier_parts
...
         supplier_parts.sno = 'S1'  OR
         parts.pname = 'Screw'
       )