Thanks I actually resolved this. I wasn't using a UNION operator
On Wed, Mar 17, 2010 at 5:50 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > Felipe Aramburu wrote: > > stmtGetQuestionsNewSystemType.text = 'SELECT > DISTINCT > > Question.id > > AS id, Question.name AS name, Question.label AS label, > > Question.datatypeid AS datatypeid, Question.advanced AS advanced, > > Question.multivalue AS multivalue, Question.measurementtypeid AS > > measurementtypeid, Question.hotlist AS hotlist FROM main.Question, > > main.CategoryQuestions, main.ApplicationQuestions, > > main.TechnologyQuestions WHERE (Question.id = > > CategoryQuestions.questionid AND CategoryQuestions.categoryid = > > @categoryid ) OR (Question.id = ApplicationQuestions.questionid AND > > ApplicationQuestions.applicationid = @applicationid ) OR (Question.id > > = TechnologyQuestions.questionid AND TechnologyQuestions.technologyid > > = @technologyid ) ;'; > > Try this: > > select /* what you have now, without DISTINCT */ > from Question where id in ( > select questionid from CategoryQuestions where categoryid = @categoryid > union all > select questionid from ApplicationQuestions where applicationid = > @applicationid > union all > select questionid from TechnologyQuestions where technologyid= > @technologyid > ); > > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
