Re: more information on JOINs

On Sat, Sep 22, 2001 at 08:11:03AM -0400, postgresql wrote:
> Where can I get more information and  examples on using JOINs. I 
> have been reading over the Chapter 2 on from the interactive user 
> docs but I need a little more in the  way of examples. I am having a 
> problem understanding when I would need a LEFT or RIGHT JOIN. 
> 
> Please, a 'point' in the right (no pun intended) direction would be 
> appreciated.
> 
> Ted
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 
> end of the original message

Take a look at the reference manual, part I "SQL Commands":

http://www.ca.postgresql.org/users-lounge/docs/7.1/reference/sql-select.html
Francesco Casadei