金蝶K3数据库开发:业务单据对于模块

SELECT it.FID,it.FFunctionID as FSubSysID,it.FName_CHS as FName,tdfss.FName as FSysName
 FROM ICClassType it 
 INNER JOIN t_DataFlowSubSystem tdfss ON it.FFunctionID=tdfss.FSubSysID 
 WHERE it.FName_CHS like '%销售订单%'
 ORDER BY tdfss.FName,it.FName_CHS

 

posted @ 2019-10-11 15:51  唐尧  阅读(477)  评论(0编辑  收藏  举报