sql experts
sql experts
Out of context: Reply #4
- Started
- Last post
- 4 Responses
- kinetic0
damn, that didn't work
basically the problem my query has is this
lets say the correct answers are 1,2,3,4
on 2006-07-01 the user votes 1,2,3,5
on 2006-07-02 the user votes
1,7,9,10my query will take the fact that they have a total of 4 right even though they where voted on different days...so i need to add another where clause to that query but im not sure how to go about that....i tried a sub select, but no go (because of mysql 3.23)