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

Query for Functions Without a Description

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