Help with script

Other SQL Server Topics
1

Hello - The script below only works when a single "AND (ActiveTask.TaskName" under JOIN ActiveTask is used (both work when used individually). How can I revise this so I can use both?

SELECT DISTINCT P.PRACT_ID, CONCAT(Last_Name, ', ', First_Name, ' ', Middle_Initial, ', ', Degree) as Practitioner_Name, MSOW_users.Username as Specialist, AP.ProcessName
FROM Practitioner P
JOIN ActiveProcess AP on AP.PRACT_ID = P.PRACT_ID
AND AP.ProcessName like 'CVO%'
JOIN Practitioner_Facilities PF ON PF.PRACT_ID = P.PRACT_ID
AND PF.Current_status = 'Active'
JOIN MSOW_USERS ON MSOW_USERS.UserID = AP.MSEmployeeAssigned
JOIN ActiveTask ON ActiveTask.ActiveProcess_ID = AP.ActiveProcess_ID
AND (ActiveTask.TaskName = 'Notify Auditor' AND ActiveTask.ActualCompleteDate IS NOT NULL)
AND (ActiveTask.TaskName = 'Audit Complete & Errors Fixed' AND Task.ActualCompleteDate IS NULL)

2 
JOIN ActiveTask ON ActiveTask.ActiveProcess_ID = AP.ActiveProcess_ID
AND
(
    (ActiveTask.TaskName = 'Notify Auditor' AND ActiveTask.ActualCompleteDate IS NOT NULL)
    OR
    (ActiveTask.TaskName = 'Audit Complete & Errors Fixed' AND Task.ActualCompleteDate IS NULL)
)