K3cloud数据字典
jacck
3人赞赏了该文章
3,548次浏览
编辑于2017年07月15日 14:47:37
/* 功能查询 2017/7/5 17:28:38 (QP5 v5.287) */
SELECT L.FNAME,
H.FNAME,
B.FNAME,
E.FNAME
FROM T_META_CONSOLESUBFUNC A
JOIN T_META_CONSOLESUBFUNC_l B
ON A.FSUBFUNCID = B.FSUBFUNCID AND B.FLOCALEID = 2052
JOIN
(SELECT C.FSUBFUNCID, C.FOBJECTID, D.FNAME
FROM T_META_CONSOLEDETAIL C
JOIN T_META_CONSOLEDETAIL_l D
ON C.FDETAILFUNCID = D.FDETAILFUNCID AND D.FLOCALEID = 2052)
E
ON A.FSUBFUNCID = E.FSUBFUNCID
JOIN
(SELECT F.FID, G.FNAME, F.FTOPCLASSID
FROM T_META_SUBSYSTEM F
JOIN T_META_SUBSYSTEM_l G
ON F.FID = G.FID AND G.FLOCALEID = 2052) H
ON A.FSUBSYSTEMID = H.FID
JOIN
(SELECT J.FTOPCLASSID, K.FNAME
FROM T_META_TOPCLASS J
JOIN T_META_TOPCLASS_L K
ON J.FTOPCLASSID = K.FTOPCLASSID AND K.FLOCALEID = 2052) L
ON H.FTOPCLASSID = L.FTOPCLASSID
ORDER BY L.FNAME,
H.FNAME,
B.FNAME,
E.FNAME
SELECT L.FNAME,
H.FNAME,
B.FNAME,
E.FNAME
FROM T_META_CONSOLESUBFUNC A
JOIN T_META_CONSOLESUBFUNC_l B
ON A.FSUBFUNCID = B.FSUBFUNCID AND B.FLOCALEID = 2052
JOIN
(SELECT C.FSUBFUNCID, C.FOBJECTID, D.FNAME
FROM T_META_CONSOLEDETAIL C
JOIN T_META_CONSOLEDETAIL_l D
ON C.FDETAILFUNCID = D.FDETAILFUNCID AND D.FLOCALEID = 2052)
E
ON A.FSUBFUNCID = E.FSUBFUNCID
JOIN
(SELECT F.FID, G.FNAME, F.FTOPCLASSID
FROM T_META_SUBSYSTEM F
JOIN T_META_SUBSYSTEM_l G
ON F.FID = G.FID AND G.FLOCALEID = 2052) H
ON A.FSUBSYSTEMID = H.FID
JOIN
(SELECT J.FTOPCLASSID, K.FNAME
FROM T_META_TOPCLASS J
JOIN T_META_TOPCLASS_L K
ON J.FTOPCLASSID = K.FTOPCLASSID AND K.FLOCALEID = 2052) L
ON H.FTOPCLASSID = L.FTOPCLASSID
ORDER BY L.FNAME,
H.FNAME,
B.FNAME,
E.FNAME