Additional Queries › Functions and Processes › Query for Processes Without a Description

Query for Processes Without a Description

SELECT M.NAME, M.CR_DATE,M.CR_TIME, B.NAME,
 FROM
 MODEL M,
 PROCESS_DEF B,
 WHERE
 M.NAME='my model name'
 AND M.ID=B.MODEL_ID
 AND B.ID NOT IN
 (SELECT E.ID
 FROM
 MODEL C,
 DESCRIPTION D,
 PROCESS_DEF E
 WHERE
 C.NAME=M.NAME
 AND C.ID=E.MODEL_ID
 AND E.ID=D.ID)
ORDER BY M.NAME, B.NAME;