Hi, Does anyone know a query that I could use to pull change records where a technican has not done an impact anaylsis? Here is what we have so far but we are not getting distinct change records.
SELECT AL1."CHANGE_ID", AL1."MANAGER_NAME", AL1."MANAGER_SUPPORT_GROUP", AL1."SCHEDULED_START_DATE", AL1."SUMMARY", AL1."STATUS", AL1."RISK", AL1."MANAGER_SUPPORT_COMPANY", AL1."ASSIGNEE_NAME", AL2."RELATED_ID", AL2."ASSOCIATION_ID", AL2."INSTANCE_ID", AL2."ASSET_ID", AL3."NAME", AL4."INFO_TYPE", AL4."NOTES" FROM "AITREMEDYDW"."CHANGE" AL1, "AITREMEDYDW"."RELATED_CI" AL2, "AITREMEDYDW"."CI_BASE_ELEMENT" AL3, "AITREMEDYDW"."CHANGE_WORK_INFO" AL4 WHERE (AL2."RELATED_ID"=AL1."CHANGE_ID" AND AL2."ASSET_ID"=AL3."RECONCILIATION_IDENTITY" AND AL4."CHANGE_ID"=AL1."CHANGE_ID") AND AL4."INFO_TYPE"='Service Impact Assessment' AND (NOT AL4."NOTES" LIKE 'Atrium Impa%'))) Thanks for all the help in advance _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"