-------------------------------------------------
--方案名称:格式化搜索相关使用信息
--使用说明:查询个数据格式化搜索所用单据及字段设置信息
--制作: 五六零网校 www.sap560.com
-------------------------------------------------
SELECT T3.FormID, T3.ItemID, T3.ColID, T3.ActionT, T3.QueryId
	, T3.IndexID, T3.Refresh, T3.FieldID, T3.FrceRfrsh, T3.ByField
	, T0.CatName AS '查询分类', T1.QName AS '报表名称',T1.QString as'报表代码'
FROM CSHS T3
	INNER JOIN OUQR T1 ON T1.IntrnalKey = T3.QueryId
	INNER JOIN OQCN T0 ON T0.CategoryId = T1.QCategory
ORDER BY T3.FormID

发表回复

后才能评论