|
-
Dec 10th, 2012, 03:05 PM
#1
Thread Starter
Frenzied Member
Question on sql
I have 2 tables one is called Question, and another one is called Section.
In Section, there's sectionID, sectionName
In Question, there's sectionID, questionID, and question
What I am trying to a ccomplish is to retrieve the sectionName then list the questions that are under that section out. I have tried inner join, left join, but I am getting the sectionName every single time I print each question out. I just want it to appear once. I was going to do group by, but it's saying my statement is not sum, max/min.
Section1
Question1
Question2
Section2
Question3
Question4
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|