On Sat, Jul 22, 2006 at 01:38:38PM -0700, [EMAIL PROTECTED] 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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to