9.1 vs. 8.0 Query

All,

We’ve been successful porting almost all of our queries from 8.0 to 9.1. However, there is one particular query that we cannot find the new table joins.

I need to enter a username and the query return all roles per product team where that user exists. I’ve attached the query that works in 8.0. Does anyone have a solution for 9.1?

qml or sql will suffice.

Thanks,

Darin Sensabaugh