--Sql Server 2014 Express Edition

--Batches are separated by 'go'

​

create table Table1(

user1 varchar(10), 

monday varchar(10)

);

insert into table1 values('user1','gym');

insert into table1 values('user1','run');

insert into table1 values('user2','gym');

insert into table1 values('user5','gym');

​

​

create table Table2(

user1 varchar(10), 

tuesday varchar(10)

);

insert into table2 values('user1','run');

insert into table2 values('user3','gym');

insert into table2 values('user4','gym');

insert into table2 values('user2','run');

​

SELECT COALESCE(t1.user1, t2.user1) AS "User", 

       t1.monday, 

       CASE 

         WHEN t2.tuesday = t1.monday THEN NULL 

         ELSE t2.tuesday  

       END as Tuesday

FROM   table1 t1 

       FULL JOIN table2 t2 

              ON t1.user1 = t2.user1 

ORDER  BY "user";