I have a table that lists 100 employees information. One of the fields is a number code, which has many diff codes for some employees. The specific code I want is "001".
I know how to make the query work for just that code, it returns 50 employees.
Here is what I want. A query that will return all employees with the 001 code and the employees that dont have the 001 code.