云星空K3Cloud常用SQL总结

--物料名称

select m.fmaterialid,m.fmasterid, fname,m.fnumber from t_bd_material m join

t_bd_material_l l on

l.fmaterialid=m.fmaterialid

where 1=1

--and m.fmaterialid=147002

and m.fnumber='XACPWM0067'

--and l.fname like '%钢筋%'

order by m.fmaterialid desc

--组织

select V_SCM_OWNERORG_L.FNAME,* from V_SCM_OWNERORG left join V_SCM_OWNERORG_L

on

V_SCM_OWNERORG.FORGID=V_SCM_OWNERORG_L.FORGI