Here is the query
SELECT ACTION_ID
, ACTION_NAME
,pd_id
, PD_NAME
, PT_NAME
, PD_GLOBAL_JOIN.GP_VALUE
, PD_GLOBAL_JOIN.GP_NAME
, AV_VALUE
, AV_GLOBAL_JOIN.GP_VALUE AV_GLOBAL_JOIN_GP_VALUE
, AV_GLOBAL_JOIN.GP_NAME AV_GLOBAL_JOIN_GP_NAME
, AV_GLOBAL_JOIN.GP_DESCRIPTION AV_GLOBAL_JOIN_GP_DESCRIPTION
, AV_GLOBAL_JOIN.GP_PROJECTID AV_GLOBAL_JOIN_GP_PROJECTID
, AV_GLOBALPARAMETERID
FROM VMTP_ACTION
LEFT JOIN VMTP_PARAMETERDEFINITION ON
(ACTION_ID = PD_ACTIONID
AND PD_METASTATUS = 1)
LEFT JOIN VMTP_ACCEPTEDVALUE ON
(PD_ID = AV_PARAMETERDEFINITIONID)
LEFT JOIN VMTP_GLOBALPARAMETER AV_GLOBAL_JOIN ON
(AV_GLOBALPARAMETERID = AV_GLOBAL_JOIN.GP_ID)
LEFT JOIN VMTP_PARAMETERTYPE ON
(PD_PARAMETERTYPEID = PT_ID)
LEFT JOIN VMTP_GLOBALPARAMETER PD_GLOBAL_JOIN ON
(PD_DEFAULT_GLOBALPARAMETERID = PD_GLOBAL_JOIN.GP_ID)
WHERE ACTION_ID IN (166)
order by pd_name;
Received on Mon Dec 04 2006 - 18:19:24 CST
