Re: [sqlite] INNER JOIN, JOIN Confusin

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

Re: [sqlite] INNER JOIN, JOIN Confusin

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

Re: [sqlite] INNER JOIN, JOIN Confusin

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

Re: [sqlite] INNER JOIN, JOIN Confusin

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?

Re: [sqlite] INNER JOIN, JOIN Confusin

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

Re: [sqlite] INNER JOIN, JOIN Confusin

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()

Re: [sqlite] INNER JOIN, JOIN Confusin

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

Re: [sqlite] INNER JOIN, JOIN Confusin

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

Re: [sqlite] INNER JOIN, JOIN Confusin

"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

Re: [sqlite] INNER JOIN, JOIN Confusin

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

Re: [sqlite] INNER JOIN, JOIN Confusin

"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

Re: [sqlite] INNER JOIN, JOIN Confusin

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

[sqlite] INNER JOIN, JOIN Confusin

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 .