Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.236.160])
	by postgresql.org (Postfix) with ESMTP id 2D232478EA3
	for <pgsql-docs@postgresql.org>; Mon, 15 Apr 2002 11:12:24 -0400 (EDT)
Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian))
	id 16x8A9-0004kf-00; Mon, 15 Apr 2002 09:13:01 -0600
Date: Mon, 15 Apr 2002 09:13:01 -0600
From: Roberto Mello <rmello@cc.usu.edu>
To: MJS <M.Sacha@elka.pw.edu.pl>
Cc: pgsql-docs@postgresql.org
Subject: Re: documentation for joins
Message-ID: <20020415151301.GA17883@cc.usu.edu>
References: <Pine.SOL.4.30.0204132318340.20964-100000@mion.elka.pw.edu.pl>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
In-Reply-To: <Pine.SOL.4.30.0204132318340.20964-100000@mion.elka.pw.edu.pl>
User-Agent: Mutt/1.3.28i
X-message-flag: Please consider using an e-mail program other than Outlook.
	It's insecure.
X-Archive-Number: 200204/20
X-Sequence-Number: 1345

On Sat, Apr 13, 2002 at 11:24:30PM +0200, MJS wrote:
> Hi!
> I found that there's no any suffiction documentation for joins. Are they
> supported in Postgres? If so, how? How to make outter joins or natural
> joins? Is the where clause the only way to join tables?

Sure they are. You didn't look very hard apparently.

PostgreSQL 7.2.1 User's Guide
2. Queries
2.2. Table Expressions
    2.2.1. FROM clause
	2.2.1.1. Joined Tables
    2.2.2. WHERE clause

http://www.postgresql.org/idocs/index.php?queries.html

How about the reference manual? It has a whole spew on joins on the
documentation for SELECT.

http://www.postgresql.org/idocs/index.php?sql-select.html

-Roberto

-- 
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ 
       http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer    
In Borland you are never bored!