Database view was not working fine on group member and user has role and group has role table

[aravindk591]

I created a database view called User_Group_Role_View using the Group Member, User Has Role, and Group Has Role tables. However, the view is generating incorrect data.

I used the WHERE clause:
ur.role = grole.role , ur.user = gr.user

Additionally, I applied a LEFT JOIN on the grmember table.

Could anyone help me identify and fix the issue?

[Kieran Anson]

Can you share a screenshot? Of the database view record and then the related list to fully understand your database view. You shouldn't have periods, but underscore characters in place of periods.

What's the intention of this db_view? 

[Ankur Bawiskar]

@aravindk591 

As shared by @Kieran Anson please share your db view screenshots.

If my response helped please mark it correct and close the thread so that it benefits future readers.