Join Multiple Columns and Get value in Same Column.

(select student.id,student.name,sit.activity from Student right join sit on student.id = sit.id ) union
( select student.id,student.name,stand.activity from Student right join stand on student.id = stand.id )
 union ( select student.id,student.name,jump.activity from Student right join jump on student.id = jump.id )




This query will produce your desired output.

Afterwards , i will tell you how we will put join in these tables and will fetch the desired result you want. Tell soon and marked the answers , if you are agree to me.

Above query will create a structure and records in your database . please check these, does they contain the type of records you want to process.

Create table student
(
id  int not null primary key , name  varchar(10)
)

create table sit
(
id  int foreign key references student(id),
activity varchar(5)
)

create table stand
(
id int foreign key references student(id),activity varchar(5)
)

create table jump
(
id int foreign key references student(id),activity varchar(5)
)

insert into student(id,name) values(1,'RAM')
insert into student(id,name) values(2,'VENU')
insert into student(id,name) values(3,'MAHESH')
insert into student(id,name) values(4,'DINESH')
insert into student(id,name) values(5,'RAhiM')

insert into sit(id,activity) values(1,'sit')
insert into sit(id,activity) values(2,'sit')


insert into stand(id,activity) values(3,'stand')


insert into jump(id,activity) values(4,'jump')
insert into jump(id,activity) values(1,'jump')