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