TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Adhikar Patil
NA
481
127.5k
How to join the below table and getting the below output res
Apr 12 2018 8:33 AM
Hello
I Have one table- CourseMaster that contains two columns
CourseId CourseName
1 Asp.Net
2 C#
3 SQL
4 VB
And Now i am having one table OrganisationMaster contains two Columns
OrgId Name CourseOffered
1 Mauli 1,4
2 SVS 3,4
3 Prompt 2,1
So i need query results as below
Name CourseOffered
Mauli Asp.Net, VB
SVS SQL, VB
Prompt C#, Asp.Net
So How to write query to get the above result?
Reply
Answers (
2
)
How create external table in database using SQL server?
My Sql Average Days sales