Show me all products supplied by supplier id 2. | Do you mean the product ID of all products supplied by supplier id 2? | Yes
SELECT product_id from Product_Suppliers where supplier_id  =  2
products supplied by supplier id 2 refers to rows in Product_Suppliers where supplier_id = 2; product ID of all these products refers to SELECT product_id;