Thanks you for all your help! FMI: Is it possible for it to return not distinct pairs also?
Thanks again! Igor Tandetnik wrote: > > Cnichols <cnichol...@gmail.com> 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? ... also kind >> of confusing > > This means you have multiple records in Stats containing the same > (SessionId, QuestionId) pair. There are 46 records total, but only 29 > distinct pairs. > > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/INNER-JOIN%2C-JOIN-Confusin-tp21676221p21688942.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users