update a
set name=b.name,
color=isnull(c.color,''),
type=isnull(d.type,'')
from a inner join b on a.id=b.id
left join c on b.color=c.id
left join d on b.type=d.id
set name=b.name,
color=isnull(c.color,''),
type=isnull(d.type,'')
from a inner join b on a.id=b.id
left join c on b.color=c.id
left join d on b.type=d.id
update A set name=b.name,color=c.color,type=d.type
from a
join b on a.id=b.id
join c on b.color=c.id
join d on b.type=d.id