Received: from news.tht.net (news.hub.org [216.126.91.242]) by hub.org (8.9.3/8.9.3) with ESMTP id GAA70454 for ; Sat, 27 May 2000 06:27:46 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.9.3/8.9.3) id GAA15379 for pgsql-sql@postgresql.org; Sat, 27 May 2000 06:27:25 -0400 (EDT) (envelope-from news) X-Authentication-Warning: news.tht.net: news set sender to using -f Message-ID: <392FA38F.C355ED6B@ids.net> From: CB Reply-To: craigbe@ids.net X-Mailer: Mozilla 4.7 [en] (Win98; U) X-Accept-Language: en MIME-Version: 1.0 X-Newsgroups: comp.databases.postgresql.sql Subject: joins again Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 9 X-Abuse-Info: Please be sure to forward a copy of ALL headers X-Abuse-Info: Otherwise we will be unable to process your complaint properly X-Complaints-To: support@usenetserver.com Organization: WebUseNet Corp http://www.usenetserver.com - Home of the fastest NNTP servers on the Net. Date: Sat, 27 May 2000 06:29:35 -0400 To: pgsql-sql@postgresql.org X-Archive-Number: 200005/173 Hi, Can someone tell me which (if any) joins are supported with 7? It appears the answer is 'none' but I want to make sure. Since I think the answer is 'none' can someone tell me how you emulate inner and outer joins using the where clause (I need an example)? Thanks! Craig