Creating a DataBase View with Multi Row variable Set table

[Insider]

I am trying to create a DB view between 2 tables MRVS table "sc_multi_row_question_answer " and a CSM case table.

I was able to pull all the MRVS variable values using the where clause "mrvs_parent_id=lr_sys_id". 
But, there is one variable of type reference (referencing user table) which is giving me value of sys_id on the DB view.

Tried many things but didn't work. 

Any help would be appreciated. Thank You

[k_lutz]

Hello. Please see if this may help. Not sure reporting against an MRVS will be useful as in most cases you run into a 1:M situation or the situation several times and its not the "flat" view most people like to see of data. I tried it against the RITM table for a MRVS and a reference field that was for a building table.