Good morning every body.. I am really need your help ASAP. pleeeeeese my dears. I work on .net program but I get stock in point. I need help in sql command.
I have tables:
notes: GroupPI_ID is same as Faculty_ID
how can write statement that retrieve groupName, student who participate in this group, and GroupPI_ID (faculty_ID)?
I hope you understand my question.
please help me in my senior project.
Answer by David Wimbush ·
select f.Faculty_name, rg.Group_Name, s.student_name from Student_group sg inner join Student s on s.Student_id = sg.Student_id inner join Rechearch_Group rg on rg.Group_ID = sg.Group_ID inner join Faculty f on f.Faculty_ID = rg.GroupPI_ID order by f.Faculty_name, rg.Group_Name, s.student_name