SELECT PARENT_PROCESS_ID, CHILD_PROCESS_ID from AMW_PROCESS_HIERARCHY_V union select -1, amwpobv.top_process_id from amw_process_org_basicinfo_v amwpobv WHERE amwpobv.top_process_id is not null
View Text - HTML Formatted
SELECT PARENT_PROCESS_ID , CHILD_PROCESS_ID FROM AMW_PROCESS_HIERARCHY_V UNION SELECT -1 , AMWPOBV.TOP_PROCESS_ID FROM AMW_PROCESS_ORG_BASICINFO_V AMWPOBV WHERE AMWPOBV.TOP_PROCESS_ID IS NOT NULL