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
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