Thanks you for all your help! FMI: Is it possible for it to return not distinct pairs also?
Thanks again! Igor Tandetnik wrote: > > Cnichols <[email protected]> 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 > [email protected] > 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
