使用传递数据自我加入更新查询

I have below tables with employee and his colleagues data,i want to update bucketid in Employee table, if there is matching Colleagues with the other employee. I have below tables with employee and his colle