so I have this table with lets say three fields
id primary key
I would like to get a list of items where staffid has different active flags. You can have staffid with multiple locations, but they should have the same flag. So I want to generate a query of staffid where the "active" flag is not consistent (its not all either 0 or 1)
some staffid can occur 1 time in the list, (we want to ingnore those) some may have 2 occorunces, some 3 or even more. I would like to generate a list of those with more than 1 occurrence where the active flag is not consistent.
thanks in advance