SELECT item_id, color FROM catalog_pet
   LEFT JOIN colors USING (item_id);