Creating a DataBase View with Multi Row variable Set table

[Insider]

I am trying to create a DB view between 2 tables MRVS question answer 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

[Michael Jones -]

There isn't a "good" way to solve this, exactly. 

You are seeing sys_id as that is the actual value stored in the table that is part of your view. In order to see something like the "name" of the referenced user, you would have to add the sys_user table to your view and create a where clause to show records that have a sys_id matching the value.

That would mean you'd see a column in your table that would be a reference to sys_user that would be empty for every other variable, and would only have a value when the actual variable value matches a sys_id for a sys_user record. 

[Insider]

Hello,

I tried doing this but i was nti able to build a where clause between user table and MRVS question answer table.

Can you please help me on that?