Product table>> (products)
id , Product_name
Product Attributes table >> (product_attributes)
id , product_id , attribute_type , attribute_value
SELECT p.Product_name , a.attribute_value FROM products p JOIN product_attributes a ON p.id = a.product_id WHERE a.attribute_type = 'type_xxx'...