counting the frequency of a link_id

[gregsa]

Hi,

This is probably a very simple problem, but I'm fairly new to SQL. Any help you can provide is greatly appreciated.

I have two tables (QUESTION and ANSWER). The ANSWER table is linked to the QUESTION table as QUESTION.id = ANSWER.question_id. What I need to do is return a bunch of fields from the QUESTION table along with the number of answers for that particular question. There may be no or many entries in the ANSWER table for a particular QUESTION entry.

So, in summary, I would like to return, say, the QUESTION.name field + the number of times it has been answered.

Thanks,

Greg

 

[tlbroadbent]

Select a.QuestionName, count(b.ID) As AnsCnt
From Questions As a
Inner Join Answers As b
On a.ID=b.Question_ID
Group by a.QuestionName Terry

http://members.home.net/tlbroadbent/prog.htm

Neither success nor failure is ever final. -Roger Babson