Received: from symcom.com ([209.11.41.82]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8MC4Ue07500 for ; Sat, 22 Sep 2001 08:04:30 -0400 (EDT) (envelope-from pgsql@symcom.com) Message-Id: <200109221204.f8MC4Ue07500@postgresql.org> Received: from WorldClient [209.11.41.82] by symcom.com [209.11.41.82] with SMTP (MDaemon.v3.5.0.R) for ; Sat, 22 Sep 2001 08:11:03 -0400 Date: Sat, 22 Sep 2001 08:11:03 -0400 From: "postgresql" To: "PgSQL-SQL" Subject: more information on JOINs X-Mailer: WorldClient Pro 2.2.1 X-MDRemoteIP: 209.11.41.82 X-Return-Path: pgsql@symcom.com X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-Archive-Number: 200109/189 X-Sequence-Number: 4871 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