From: Anthony Kinyage <kinyage_tony@yahoo.com>
To: onin <jnana@mobius.ph>
Cc: pgsql-sql@postgresql.org
Subject: Re: table joining duplicate records
Date: Sat, 8 Jul 2006 11:35:03 +0100 (BST)
Message-ID: <20060708103503.45211.qmail@web51910.mail.yahoo.com> (raw)
In-Reply-To: <44AF748C.2010100@mobius.ph>
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 are on Question_answer Table, in your case you can use the following:
SELECT * FROM question_answer;
Try this STATEMENT
onin <jnana@mobius.ph> wrote: 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:category
----------------
1 :category1
questions
question_id:question
----------------
1 :question1
answers
answer_id:answer
----------------
1 :answer1
2 :answer2
questions_answers
question_answer_id:survey_id:category_id:question_id:answer_id
1 :1 :1 :1
1 :1 :1 :2
and my query looks like this
select s.survey, c.category, q.question, a.answer from questions_answers
qa, answers a, questions q, categories c, surveys s
where qa.answer_id = a.answer_id and qa.question_id = q.question_id and
qa.category_id = c.category_id and qa.survey_id = s.survey_id;
after executing the code,
i get results like this.
--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?
any help would be appriciated.
thanks in advance.
--
"A whim, a thought, and more is sought... awake, my mind... thy will be wrought!"
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
---------------------------------
Try the all-new Yahoo! Mail . "The New Version is radically easier to use" – The Wall Street Journal
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: kinyage_tony@yahoo.com, jnana@mobius.ph
Subject: Re: table joining duplicate records
In-Reply-To: <20060708103503.45211.qmail@web51910.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox