Join Multiple Columns and Get value in Same Column.

Question

i have four tables eg Student table - table ID - Name - Sit table ID Stand table ID Jump Table ID where Student table is Master and all other are foriegn key to ID column in other tables. Student table 1 Ram 2 Venu 3 Mahesh 4 Dinesh 5 Rahim Sit table 1 2 Stand table 3 Jump table 4 1 I want a query which will result in following structure StudentID StudentName ActivityDone 1 Ram Sit 2 Venu Sit 3 Mahesh Stand 4 Dinseh Jump 5 Rahim None 6 Ram Jump Please can any one help me...

Ashish · Answer

(select student.idstudent.namesit.activity from Student right join sit on student.id = sit.id ) union ( select student.idstudent.namestand.activity from Student right join stand on student.id = stand.id ) union ( select student.idstudent.namejump.activity from Student right join jump on student.id = jump.id ) This query will produce your desired output.

Ashish · Answer

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.

Ashish · Answer

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.

Ashish · Answer

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(idname) values(1'RAM') insert into student(idname) values(2'VENU') insert into student(idname) values(3'MAHESH') insert into student(idname) values(4'DINESH') insert into student(idname) values(5'RAhiM') insert into sit(idactivity) values(1'sit') insert into sit(idactivity) values(2'sit') insert into stand(idactivity) values(3'stand') insert into jump(idactivity) values(4'jump') insert into jump(idactivity) values(1'jump')