万事开头难

 

select * from ma_foundation mf where mf.id='50104447' and mf.name='BOM'--guid=1F1E361D0EC24853B0B04ECC70D125FF 
select * from bomview_r bv where bv.foundationfk='1F1E361D0EC24853B0B04ECC70D125FF'--guid=2F29A1FCF82046838978237A2E488442
select * from bomstructure bs where bs.viewfk='1F1E361D0EC24853B0B04ECC70D125FF'--10 个
select distinct mf.id,bs.rsflag from bomstructure bs,ma_foundation mf 
     where mf.masterfk= bs.end2masterguid and  bs.guid in 
        (select bs.guid from bomstructure bs where  
               bs.viewfk='1F1E361D0EC24853B0B04ECC70D125FF')
--搜索出来的37000006这个bomstructure的rsflag=Y ，即错误数据