.Jeff,

I'm not sure how to change the code?

Thanks again.

left JOIN ContractorCoverageException cce ON cce.contractorcoverageID = a.ID and cce.PostalID = postal.ID and e.postalid is null

-- and not exists (select postalid from ContractorCoverageException e where e.contractorcoverageid = ContractorCoverage.id and postalid = postal.id)