I'm looking for some help in identifying / joining some tables. I need a basic query that returns a Resources name, and their Primary Role. Both fields are displayed in the attached screenshot. I have located the Resource Name in the SRM_RESOURCES table, but I can't find where the Primary Role is stored, or how to join it to my Resource table.
Thanks in advance!