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
younis abdeljawwad
NA
73
96.9k
select from many to many relation in sql server 2008(in visual studio 2010 professional)
May 28 2012 1:57 PM
Hi Friends,
I have relation Many-to-Many between [class] table and [student] table which is [class student]
[class student] have the primary key of [class] and [student]
now i want to select from table students first_name,last_name given class_id
i mean i want to select the first_name and the last_name of the student that register in that class which have the given class_id
Reply
Answers (
2
)
How to fetch top 2 record through group by
Tricky SQl Querry Select Querry