Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Post
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
4
Reply
Join Multiple Columns and Get value in Same Column.
Vishwas Kadamannaya
10 years ago
779
Reply
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...
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
delete in sql
SQL QUARIE NOT SELECT 'NULL' AND '0' VALUES IN COLOUMS