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
