Received: from dmog10.bell.ca (dmog10.bell.ca [198.235.69.18]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA70828 for ; Tue, 1 Jun 1999 09:57:02 -0400 (EDT) (envelope-from phillip.zheng@cgi.ca) Received: from bascd3.on.bell.ca ([142.122.115.52]) by dmog10.bell.ca with ESMTP id JAA01978 for ; Tue, 1 Jun 1999 09:56:28 -0400 (EDT) Received: from cgi.ca ([142.122.248.21]) by bascd3.on.bell.ca (Netscape Messaging Server 3.6) with ESMTP id AAA2508 for ; Tue, 1 Jun 1999 09:56:24 -0400 Message-ID: <3753F351.BF96C3E3@cgi.ca> Date: Tue, 01 Jun 1999 09:50:57 -0500 From: "ZHENG, PHILLIP" X-Mailer: Mozilla 4.03 [en] (WinNT; U) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Outer Join Two Tables Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, I am trying to do a Left Join or Right Join with SQL, I went through the on line documentation on http://www.postgresql.org many times still cannot find any documentation or sample about it. Please provide me a simple sample. Thanks, Phillip Zheng