Previous Topic: SUBJECT_AREANext Topic: Task


Task

Select the root subject area for a model.

SELECT S.NAME
  FROM
  MODEL M,
  SUBJECT_AREA S
  WHERE
  M.NAME = 'my model name'
  AND S.MODEL_ID = M.ID
  AND S.PARENT_SUBJ_ID = 0;