SELECT T2.product_type_code ,  T2.product_name ,  T2.product_price FROM product_suppliers AS T1 JOIN products AS T2 ON T1.product_id  =  T2.product_id WHERE T1.supplier_id  =  3
Give me the product type, name and price for all the products supplied by supplier id 3.
SELECT T2.product_type_code , T2.product_name , T2.product_price FROM product_suppliers AS T1 JOIN products AS T2 ON T1.product_id = T2.product_id WHERE T1.supplier_id = 3
select t2 . product_type_code , t2 . product_name , t2 . product_price from product_suppliers as t1 join products as t2 on t1 . product_id = t2 . product_id where t1 . supplier_id = value
Give me the product type , name and price for all the products supplied by supplier id 3 .