云星空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.FORGID

select l.FNAME,* from T_ORG_ORGANIZATIONS o

join T_ORG_ORGANIZATIONS_L l on l.FORGID=o.FORGID

--部门

select b.FNAME,* from T_BD_DEPARTMENT a join T_BD_DEPARTMENT_L b on

a.FDEPTID=b.FDEPTID

--参数

select * from t_bas_sysparameter

--用户

select * from T_SEC_USER