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
