SQL语句技巧（二）

--物料名称 select m.fmaterialid,m.fmasterid, fname,m.fnumber from t_bd_material m join t_bd_material_l l on l.fmaterialid=m.fmaterialidwhere 1=1--and m.fmaterialid=147002and 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.FORGIDselect l.FNAME,* from T_ORG_ORGANIZATIONS ojoin T_ORG_ORGANIZATIONS_L l on l.FORGID=o.FORGID --元数据 select * from t_meta_objecttype_l ml,t_meta_objecttype m where fname like '%工序汇报%' and ml.fid=m.fid--部门select b.FNAME,