| 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: | Whole Thread | Raw Message | 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 |