SELECT
/* DATASET */
EMD.OID AS OIDATASET, /* NOTE1 */
EMD.IDNAME AS IDDATASET, /* NOTE2 */
EMD.NMDISPLAYNAME AS NMDATASET, /*NOTE3 */
/* FORM */
EFR.OID AS OIDFORM, /*NOTE4 */
EFR.IDFORM, /* NOTE5 */
EFR.NMFORM, /* NOTE6 */
GNR.IDREVISION /* NOTE7 */
FROM
EMDATASETMODEL EMD
INNER JOIN (
SELECT
TB.OIDREVISIONFORM,
TB.OIDDATASETMODEL
FROM (
SELECT OIDREVISIONFORM, OIDDATASETMODEL FROM EFSTRUCTFORM WHERE OIDDATASETMODEL IS NOT NULL UNION ALL
SELECT OIDREVISIONFORM, OIDDATASET FROM EFFORMELEMENT WHERE OIDDATASET IS NOT NULL UNION ALL
SELECT EFR.OIDREVISIONFORM, EFRA.OIDDATASET FROM EFRULE EFR, EFRULEACTION EFRA WHERE EFR.OID = EFRA.OIDRULE AND EFRA.OIDDATASET IS NOT NULL
) TB
GROUP BY
TB.OIDREVISIONFORM,
TB.OIDDATASETMODEL
) FORM ON EMD.OID = FORM.OIDDATASETMODEL
INNER JOIN EFREVISIONFORM EFR ON FORM.OIDREVISIONFORM = EFR.OID
LEFT OUTER JOIN GNREVISION GNR ON EFR.CDREVISION = GNR.CDREVISION
|