Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
However, that may not always be the case. Right now I do have this condition exisiting. But what about when this is not true. For example, today Store # 1 has a District Manager. Tomorrow they may not. When that happens I need to designated a District Manager type of 5. Later on the store is assigned a DM. I changed the above query to read (1,5) and it gave me this error:
AreaSM: (Select [tblEmployee.EmployeeID] FROM tblEmployee INNER JOIN tblDesignatedEmployee ON tblEmployee.EmployeeID = tblDesignatedEmployee.EmployeeID Where tblDesignatedEmployee.StoreID = tblStore.StoreNumberID And tblDesignatedEmployee.EmployeeTypeID In (4,5))