Cnichols <cnichol...@gmail.com> wrote: > 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. > > FMI: > Is it possible for it to return not distinct pairs also?
If I understand your question, your prior attempts did just that, and you weren't happy about it. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users