数据查询:格式化搜索相关使用信息
小于 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