Public Interface Export Function › Analysis Objects › Analysis Tasks Related to Data. › SUBJECT_AREA › Task

Task

Select all the subject areas and their parent subject areas. Order by parent subject area.

SELECT P.NAME, C.NAME
  FROM
  MODEL M,
  SUBJECT_AREA P,
  SUBJECT_AREA C
  WHERE
  M.NAME = 'my model name'
  AND P.MODEL_ID = M.ID
  AND C.PARENT_SUBJ_ID = P.ID
ORDER BY P.NAME;