RSI details attached to an RM classification

Arun_Ananthanarayanan

I am trying to get the RSI details that is attached to a large number of RM Classifications. I have the dataID of the Classification objects, but am not able to come up with a report that would fetch me the RSI details like the name of the RSI and its unique ID. Any tips?

John W. Simon, Jr.

Not sure this is what you are after, hopefully it will get you further along.

select *
from rm_classification rc
join rsi on rc.rsi = rsi.rsi