Re: SQL help...

Please post the sql statement that creates these tables.

-r

At 12:15 AM 5/16/01 -0400, Alex Hochberger wrote:

>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...
>
>With an ugly hack, I get the results where they answered everything, but not
>the partial answers.
>
>Please cc: me on the reply, because I get this as a digest.
>
>Thanks,
>Alex
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com)
>Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01