Find the color of the product id 2?
SELECT T2.color_description FROM Products AS T1 JOIN Ref_Colors AS T2 on T1.color_code  =  T2.color_code  WHERE product_id  =  "2"
color of the product refers to color_description; product id condition refers to WHERE product_id = '2'; joining tables involves Products and Ref_Colors on a common attribute color_code;