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
defaultnextval('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
defaultnextval('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