RE: [GENERAL] SQL help...

2001-05-15 Thread Alex Hochberger
"qa_id" int8 NOT NULL, CONSTRAINT "user_answers_pkey" PRIMARY KEY ("ua_id") ); CREATE INDEX "user_answers_qa_id_key" ON "user_answers" ("qa_id"); CREATE INDEX "user_answers_question_id_key" ON "user_answers" (&q

[GENERAL] SQL help...

2001-05-15 Thread Alex Hochberger
To any SQL wizards out there, I have finally exhausted my SQL knowledge. I have 3 tables that I need to do a fancy join on... 1 stores the users 1 stores the questions 1 stores the user's answers to the questions (based on foreign keys to the answers table) I would like to create a result with