Unanswered: Using And/Or - Not Sure Which Is Correct
This is my syntax - I want it to return records where both of this conditions are true ... Condition 1 - employeeStatus is not in ('','','','','','','') Condition 2 - employeeStatus Not Like ('%pending%')....
I think the syntax should read like so - but I am getting different results returned than what I feel is accurate so thought I would ask for assistance starting with the Where clause
Select EmployeeName, SupervisorName, employeeTotalSales, yrsOfService
Where employeeStatus Not In ('Terminated', 'No Longer With Company', 'Retired', 'Left Company', 'On Leave', 'Suspended')
OR employeeStatus Not Like ('%pending%')