Additional Queries › Action Blocks › Action Block Listing › Query for Action Block Listing

Query for Action Block Listing

SELECT M.NAME, M.CR_DATE, M.CR_TIME, B.NAME, B.INTEXT, C.TEXT
 FROM
 MODEL M,
 ACTION_BLOCK B,
 DESCRIPTION C
 WHERE
 M.NAME='my model name'
 AND M.ID=B.MODEL_ID
 AND B.ID=C.ID
ORDER BY M.NAME, B.NAME;