> 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
hi all,
somebody please help me with my sql statement.
or point me to the right documentation that i need to read.
what i want to working on right now is to create a db for a survey app
my tables look this
surveys
survey_id:survey
1: survey1
categories
category_id:cate
