Re: relational display

[daniel kessler]

The only thing that I didn't get was the first line of the WHERE p.p_id = a.pa_pollID.  It seems that if I have the last AND p.p_id = 21, then I shouldn't need that first line, but I do.  I am told by several that it's because it connects the pollID to the answerId and I know that they're correct cause it only works with that line.  It's  like this is the only line that does associating and the others do filtering, clearing out of data.  Do I need this line only because of the COUNT at the top?  I doubt it, but I dunno.

>WHERE    p.p_id = a.pa_pollID <!--- The pollid in your poll table should be
>the same poll id in your answer table, so that answers are linked with the
>poll --->

The other problem that I found is that the answers that weren't answered, so they're not in the Results table, aren't listed.  I don't know what to do about that, but the poll should list all answers and just put a 0 next to the one without any answers.

I've posted this question as it's own post, but so far have not seen an answer.  Any thoughts are welcome - very welcome really.

And I was just kiddin about the Loathe comment.  I prefer descriptive names myself, just had done this because of a suggestion.

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---