Jeff Butera <[EMAIL PROTECTED]> writes:
> UPDATE STUDENT_ANSWERS SET CORRECT=QA.CORRECT
> FROM QUESTION_ANSWERS QA,STUDENT_ANSWERS SA
> WHERE SA.CORRECT=null
> AND SA.QUESTIONS_ID=QA.QUESTIONS_ID
> AND SA.ANSWERS_ID=QA.ANSWERS_ID;
What you've got here is a three-way join between
I'm new to postgres and am having an UPDATE problem when
using a join. I've got two tables like so:
CREATE TABLE QUESTION_ANSWERS (
QUESTIONS_ID int4 NOT NULL, -- question ID
ANSWERS_ID int4 NOT NULL, -- answer ID
CORRECTboolean
);
CREATE TABLE STUDENT_ANSWERS (
S
