Re: [SQL] Data Calculation

2003-09-29 Thread Christoph Haller
According to your scenario I did the following create table answerkey ( question_number int, answer varchar(2)); create table studentanswer ( student_id varchar(6), answer01 varchar(2), answer02 varchar(2)); insert into answerkey values(1,'A'); insert into answerkey values(2,'B'); insert into stu

[SQL] Data Calculation

2003-09-29 Thread Ogden
I need some help for which I could not find much help for within the Postgres book I am looking at, or the online tutorial. I don't know if this is even possible, but here goes... I am writing for advice, as the method I followed is not the most effecient, I think. Scenario: Grading results. I ha