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...