select c.cname
from customers c, parts p
where c.cno = zipcodes.zip;
