Is this what you wantCREATE TABLE emp(name varchar(MAX),[role] varchar(MAX))INSERT INTO emp VALUES('David','role1'),('David','role2'),('Tom','role3'),('Jen','role4')CREATE TABLE role([role] VARCHAR(MAX),duty VARCHAR(MAX))INSERT INTO role VALUES('role1','duty1'),('role2','duty2'),('role3','duty3'),('role4',' duty1')CREATE TABLE duty(duty VARCHAR(MAX),conflict VARCHAR(MAX))INSERT INTO duty VALUES('duty1','duty2'),('duty2','duty1')SELECT E.name , E.[role] , d.duty , d.Conflict FROM emp EINNER JOIN role RON E.[role] = R.[Role]INNER JOIN duty dON R.duty = D.duty
---------------Murali KrishnaYou live only once ..If you do it right once is enough.......