question about a query
- From: nina297 <nina.childress@xxxxxxx>
- Date: Thu, 28 Jun 2007 12:44:17 -0700
I've written this query:
select distinct topics, questions, answer
from topics AS A, QuesNans AS B
where A.topicid = B.topicid
order by a.topics
The results are:
Topic Questions Answers
Topic Four Question 1 Answer to question 1
Topic One Quesstion 2 Answer to question 2
Topic One Question 1 Answer to question 1
Topic Three Question 1 Answer to question 1
Topic Two Question 2 Answer to question 2
How do I get one topic listed but all of the questions that go with
that topic?
.
- Follow-Ups:
- Re: question about a query
- From: Erland Sommarskog
- Re: question about a query
- From: Roy Harvey
- Re: question about a query
- Prev by Date: Re: Is Not Null and Query Optimization
- Next by Date: Re: Strange performance issue with UPDATE FROM
- Previous by thread: Is Not Null and Query Optimization
- Next by thread: Re: question about a query
- Index(es):