younis abdeljawwad

younis abdeljawwad

  • NA
  • 73
  • 96.6k

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




Answers (2)