I have a view with name of UserInfo like this:
And another view with name of UserRoleInfo like this:
I want to aggregate all the records of the two views for one user name like H.F into one view.
I tried to join the two views on user name but does not work!
How can I have all records of these two views in one view with the same columns as in picture 3?