The grouping of material lists in the foreground is different from that in the background.
Scenario: when the foreground of the material table is different from the background, or when the foreground deletes the grouping prompt to have detailed data
1. Query the fid corresponding to the grouping
Select * from T_BD_MATERIALGROUP_L where fname like'0%'
2. Find out the corresponding material fnumber
Select a.fnumber from T_BD_MATERIAL a
Left join (select fid,fname From T_BD_MATERIALGROUP_L) T4 on a.FMATERIALGROUP=t4.fid
Where t4.fname like'0% 'and FMATERIALGROUP=16416826
III. Update
Update a set a.FMATERIALGROUP=12258320 from T_BD_MATERIAL a
Left join (select fid,fname From T_BD_MATERIALGROUP_L) T4 on a.FMATERIALGROUP=t4.fid
Where t4.fname like'0% 'and FMATERIALGROUP=16416826
