Shulou(Shulou.com)06/03 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.