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 ,...
2 results in 0.0013 seconds.
-
How to seek a NOT IN RANGE condition
-
Data not eisting in tables
I amm having one of those DBA brain locks. I have two tables lets say table_1 and Table_2. The Join column in both (indexed) is col_1 ( variable character 75 ).
what I need to do is produce a record of those records in Table_1 that are not in
Table_2
over simplified example Data
Table_1 Col_1 Table_2 Col_1
abcd ...
