跳至主要內容

数据查询:格式化搜索相关使用信息

五六零网校小于 1 分钟

查询个数据格式化搜索所用单据及字段设置信息

代码示例

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