SQL Question

From: Daryl Herzmann <akrherz(at)iastate(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: SQL Question
Date: 2000-08-01 20:38:13
Message-ID: Pine.LNX.4.21.0008011531430.32478-100000@iitappc1.iitap.iastate.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,
I hope this question is not too novice for this group.

I have a table

portfolio=# \d questions
Table "questions"
Attribute | Type | Modifier
-----------+-------------+-----------------------------------------------------
qid | integer | not null default nextval('questions_qid_seq'::text)
optiona | text | default 'Z'
optionb | text | default 'Z'
optionc | text | default 'Z'
optiond | text | default 'Z'
optione | text | default 'Z'
optionf | text | default 'Z'
optiong | text | default 'Z'
optionh | text | default 'Z'

and other table named quizes, which contains references to the
questions. Basically a quiz is composed of up to three questions.

portfolio=# \d quizes
Table "quizes"
Attribute | Type | Modifier
-----------+-------------+------------------------------------------------------
quiznum | integer | not null default nextval('quizes_quiznum_seq'::text)
question1 | integer |
question2 | integer |
question3 | integer |

So my question is if I want to querry out a particular quiz and all its
questions and question options, how can I do that in one command. I know
that I could do it with a couple of loops, but I think the SQL is much
more eliquent. Maybe I have my tables incorrectly set up? And
suggestions?

Thanks all,
Daryl

Browse pgsql-sql by date

  From Date Subject
Next Message Gerhard Dieringer 2000-08-02 07:32:40 Antw: SQL Question
Previous Message Michael Richards 2000-08-01 18:32:27 Re: on line numbers, drop table errors, and log files