> can i have a result set. just like the outer join returns.
> but on my case. return null on duplicates.
> like this one.
>
> survey :category :question :answer
> ---
> survey1:category1:question1:answer1
>: : :answer2
hmmm.. I am no sure
> --query results--
> survey :category :question :answer
> survey1:category1:question1:answer1
> survey1:category1:question1:answer2
>
> how can i elimate duplicates on my query results?
> an also am i using the right 'table joining' or table design for my
> survey app?
What duplicates? You hav
In your case Survey , Categories, Questions and Answers TABLES are parents tables, and Question_answers TABLE is a Child Table. Since you want to have survery, from Survey Table, Category from Category Table, Question from Question Table and Answer from Answer Table and alll these Atributes ar
