Explanation:
PROJECTION will select the whole column values of the table while SELECTION will gives you rows of the table and JOIN is joining the two tables on a same column. To get all these task done in one statement you can use this command

 SELECT p.id_number, m.manufacturer_id, m.city 
 FROM product p, manufacturer m 
 WHERE p.manufacturer_id = m.manufacturer_id 
 AND m.manufacturer_id = 'NF10032'; 

---