>gave just used standard joins . Check out
>http://www.w3schools.com/sql/default.asp
>for some SQL basics. Think of joins as set intersections, remember
>set calculus? :)
While I didn't take calculus, just pre, and am new to this stuff, I get the Join idea, basically. It's that your way of doing it didn't use the word Join, so I didn't recognize it and a few other ways things are done.
Nonetheless, I said that it repeats values because when I look at the return:
[answerID]answer
[1]0 - 1
[2]0 - 1
...cut...
[1]2-3
[2]2-3
I see a vote/result with an ID of 1 have two answer responses (0-1, 2-3). The vote can only have one answer. I did a query where I grabbed the first poll result, which has an ID of 1, then I queried for it's answerID which then I queried for it's answer. While this isn't very efficient, it ends up with a particular value. In this case it was "5-6". So to me it should have listed [1] 5-6 once since the first vote was answered once with that value.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
