CREATE TABLE T_user
(
id INT,
name VARCHAR(20),
email VARCHAR(50),
roles INT,
)
INSERT INTO T_user(id,name,email,roles) VALUES(1,'amit','a@gmail.com',1)
INSERT INTO T_user(id,name,email,roles) VALUES(2,'sachin','s@gmail.com',2)
INSERT INTO T_user(id,name,email,roles) VALUES(3,'ravi','r@gmail.com',1)
INSERT INTO T_user(id,name,email,roles) VALUES(4,'mayank','m@gmail.com',3)
SELECT * FROM dbo.T_user
CREATE TABLE M_role
(
id INT,
role_name VARCHAR(50),
)
INSERT INTO M_role(id,role_name) VALUES(1,'admins')
INSERT INTO M_role(id,role_name) VALUES(2,'hr')
INSERT INTO M_role(id,role_name) VALUES(3,'payrol')
SELECT * FROM dbo.M_role
SELECT * FROM dbo.T_user

SELECT u.id,U.name,U.email,
(
 SELECT Role_Name FROM dbo.M_role R
    WHERE R.id=U.roles
)RoleName
 FROM dbo.T_user U



 SELECT U.Id,Name,U.email,R.role_name
  FROM dbo.T_user U
   JOIN dbo.M_role R
   ON R.id=U.roles
   SELECT * FROM  dbo.M_role
   INSERT INTO dbo.M_role
           ( id, role_name )
   VALUES  ( 78, -- id - int
             'CEO'  -- role_name - varchar(50)
             )

   SELECT * FROM dbo.T_user


   INSERT INTO dbo.T_user
           ( id, name, email, roles )
   VALUES  ( 5, -- id - int
             'Abhay', -- name - varchar(20)
             'A@gmail.com', -- email - varchar(50)
             78  -- roles - int
             )