I'm trying to build a report which highlights the Inactive Suppliers within the ERP database and have the following query which I've built but am struggling to find/apply a "not in range" condition.

SELECT DISTINCT oas_docline.el2 AS [Supplier Code], oas_element.nam e AS [Supplier Name], oas_element.add date AS [Date Created], oas_element.mod date AS [Last Modified Date], oas_element.usr name AS [Modified By], oas_element.cur ,...