Cnichols wrote:
> Igor Tandetnik wrote:
>>
>> Cnichols wrote:
>>> Ok I also tried to think about it from a different approached and
>>> didnt get the result I wanted ...
>>>
>>> SELECT COUNT() FROM Temp
>>> WHERE Id IN (SELECT QuestionId FROM Stats
Thanks you for all your help!
FMI:
Is it possible for it to return not distinct pairs also?
Thanks again!
Igor Tandetnik wrote:
>
> Cnichols wrote:
>> Ok I also tried to think about it from a different approached and
>> didnt get the result I wanted ...
>>
>> SELECT
Cnichols wrote:
> The following produces 52 results, which consists of 52 questions
> that where incorrect from session 6, the previous session, we are now
> in a new session, session 7
>
> SELECT COUNT() FROM Questions Q
> LEFT JOIN Stats S ON S.QuestionId = Q.Id
> WHERE
Cnichols wrote:
> Ok I also tried to think about it from a different approached and
> didnt get the result I wanted ...
>
> SELECT COUNT() FROM Temp
> WHERE Id IN (SELECT QuestionId FROM Stats WHERE SessionId = 7)
>
> I expected that to return 46 results .. it returned 29?
Cnichols wrote:
> Igor Tandetnik wrote:
>>
>> "Cnichols" wrote
>> in message news:21685825.p...@talk.nabble.com
>>> Stats does contain 46 qids with sids of 7
>>> there is one duplicate question now that i look harder in temp which
>>> is ok because 289
I am trying to keep my thoughts as organized as possible. I want to refresh
and try to simplify my question ...
The following produces 52 results, which consists of 52 questions that where
incorrect from session 6, the previous session, we are now in a new session,
session 7
SELECT COUNT()
Ok I also tried to think about it from a different approached and didnt get
the result I wanted ...
SELECT COUNT() FROM Temp
WHERE Id IN (SELECT QuestionId FROM Stats WHERE SessionId = 7)
I expected that to return 46 results .. it returned 29? ... also kind of
confusing
What I was thinking that
I expected it to return 46 results, not fewer as you mentioned, except it
returns 51 which I am trying to figure out why ... there is only one
duplicate in Temp, but why would that still produce more results then 46?
Igor Tandetnik wrote:
>
> "Cnichols" wrote
> in message
"Cnichols" wrote
in message news:21685825.p...@talk.nabble.com
> Stats does contain 46 qids with sids of 7
> there is one duplicate question now that i look harder in temp which
> is ok because 289 I forgot to mention that id in temp is not a key,
> this is because there is
Thanks for the reply.
Stats does contain 46 qids with sids of 7
there is one duplicate question now that i look harder in temp which is ok
because 289 I forgot to mention that id in temp is not a key, this is
because there is a test mode to ask random questions that aren't unique (so
289 was
"Cnichols" wrote
in message news:21676221.p...@talk.nabble.com
> What i am trying to do right now is select the questions that have
> been asked for the current session (ie 7)
> Stats - contains 46 rows with sessionid of 7
> Temp - holds 52 missed questions from the previous
On 27/01/2009 12:00 PM, Cnichols wrote:
> I have stumped myself with this sql goal.
>
> With this statement I am working with 3 tables
> Stats - contains question asked history and if it was answered correcty
> sessionid
> questionid
> correct
> Questions - contains a list questions and mul
I have stumped myself with this sql goal.
With this statement I am working with 3 tables
Stats - contains question asked history and if it was answered correcty
sessionid
questionid
correct
Questions - contains a list questions and mul choice answers and answer
id - pk
.
13 matches
Mail list logo