From: | Harald Fuchs <hf(at)colibri(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: SQL help... |
Date: | 2001-05-16 11:12:25 |
Message-ID: | y297kzh1rae.fsf@dorando.intern.colibri.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
In article <1F3774AB3688D4118B1300508BD9641528A7E0(at)CHINA>,
Alex Hochberger <alex(at)feratech(dot)com> writes:
> 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 the following columns:
> some fields from the users, each of the questions
> in each row should be the results from the users, and their user answers
> Here is the tricky thing, people may have not answered each question, so I
> would like to either leave that blank or put in a 0...
Sounds like a LEFT OUTER JOIN.
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Dederer | 2001-05-16 11:32:03 | Re: timestamp changed on 7.1.1 ? |
Previous Message | Al Frick | 2001-05-16 11:03:35 | Re: Which Front End for Postgresql |