Re: join table with empty fields and default

On Sat, Jul 22, 2006 at 01:38:38PM -0700, quickcur(at)yahoo(dot)com wrote:
> Suppose I have another table UserInformation
>
> UserInfomation
> {
> userid integer referenes user(id),
> mothername text
> }
>
> I would like methername also appear in the final join. Suppose each
> user must have a mothername.
>
> Could you please whow me the sql again?

Same query as before but with an additional join for the new table.
See the documentation links in my previous response for information
about join types, syntax, and examples.

What have you tried, what results were you expecting, and what
results did you get? If you're getting the wrong results then let's
investigate so we can understand why they're wrong.

--
Michael Fuhr