Ah ha, thought how to reduce the problem size down to 12 groups 🙂

Since the Roles with multiple groups consist of <=12 groups all I need to to do is...

First of all that's amazing, it give exactly the required output. Thank you very much. Currently I'm really struggling to see how it works but I'll try and disect this...

Solved it....I think...amazing what hot water on your head in the shower does.

a) count the number of rows for each role type from the roles table.

b)...

Hi,

So as far as I can see it the only table I have "control" over is the one that links Groups to Roles and IMHO the most sensible way to...

Hi. I can structure the table of roles any way required. The thing i am struggling with is the actual sql that would give me a list of users...

Hi Wendell,

Thanks for your reply.

The "table " structure can be manipulated in any way required. That's no problem,. The LDAP data is what it is though, 2 columns,...