Received: from mailrelay3.inwind.it (mailrelay3.inwind.it [212.141.54.103]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8MFfbe67187 for ; Sat, 22 Sep 2001 11:41:37 -0400 (EDT) (envelope-from _casadei@libero.it) Received: from [62.98.218.41] (62.98.218.41) by mailrelay3.inwind.it (5.5.029) id 3BA608A1002044E3 for pgsql-sql@postgresql.org; Sat, 22 Sep 2001 17:41:17 +0200 Received: (qmail 781 invoked by uid 1000); 22 Sep 2001 15:40:57 -0000 Date: Sat, 22 Sep 2001 17:40:57 +0200 From: Francesco Casadei To: postgresql Cc: PgSQL-SQL Subject: Re: more information on JOINs Message-ID: <20010922174057.A763@goku.kasby> References: <200109221204.f8MC4Ue07500@postgresql.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <200109221204.f8MC4Ue07500@postgresql.org>; from pgsql@symcom.com on Sat, Sep 22, 2001 at 08:11:03AM -0400 X-Operating-System: FreeBSD 4.4-STABLE i386 X-Archive-Number: 200109/190 X-Sequence-Number: 4872 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