Databases Forum

I'm trying to get one row returned for a display of a public phone extension and I'm just not seeing something clearly. I want to check directly in my query that if someone has multiple extensions to only get one based on rules:

A person can have up to 3 types

7000 range is for voicemail 3000 range is for direct 5000 is a boss group (rings multiple phones, ie secretary)

A few administrators that have been promoted through the years started with just voicemail, then got a direct extension, then got a boss group, so I have a "worse case" with them that could look like this:

Name|Ext ------|------- User | 7140 User | 5620 User | 3259

The rules follow:

If someone has a 5000 range, get that one as 'Public Extension' else If they have a 3000, get that one as 'Public Extension' else get 7000 as 'Public Extension'. Is this possible to do directly in the query?