update dog_type d,dbo.dogCodeColor c set d.dog_color = c.dogColor where d.dog_breed_code = c.dogCode;