• You can also get rid of the not exist altogether by doing a LEFT JOIN to ContractorCoverageException cce...

    Then in the WHERE clause...

    WHERE cce.contractorcoverageid IS NULL