update a set a.orderby = b.orderby
from bgfl a, (select orderby, bgflbh from bgfl where orderby <> 0) b
where substring(a.bgflbh, 1, 6) = b.bgflbh