组合具有相同名称的两列数据以创建视图

I am working on a project and for my login credentials checking process I am trying to create a view in which the name,surname,username and password of customers,workers and admins are stored so that I can search faster and I have two questions. I am working on a project and for my login cred