X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 4FC5CD1B4FD for ; Tue, 30 Sep 2003 07:54:14 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 83310-05 for ; Tue, 30 Sep 2003 04:53:47 -0300 (ADT) Received: from smtp.noos.fr (nan-smtp-10.noos.net [212.198.2.81]) by svr1.postgresql.org (Postfix) with ESMTP id 4B6BCD1B50A for ; Tue, 30 Sep 2003 04:53:45 -0300 (ADT) Received: (qmail 148074431 invoked by uid 0); 30 Sep 2003 07:53:08 -0000 Received: from unknown (HELO bigfoot.com) ([212.198.37.110]) (envelope-sender ) by 212.198.2.81 (qmail-ldap-1.03) with SMTP for ; 30 Sep 2003 07:53:08 -0000 Message-ID: <3F793653.3070300@bigfoot.com> Date: Tue, 30 Sep 2003 09:52:51 +0200 From: Gaetano Mendola User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5b) Gecko/20030901 Thunderbird/0.2 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Cc: sad Subject: Re: SQL Syntax problem References: <200309281443.09936.bedo7@gmx.net> <200309300922.06402.sad@bankir.ru> In-Reply-To: <200309300922.06402.sad@bankir.ru> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/419 X-Sequence-Number: 15397 sad wrote: >>select ... >>from auswahlkatalog k, anspruchkorrektur a, beteiligter b, v_betkorr f >>where k.awk_id = a.awk_id and b.bet_id(+) = a.bet_idemp >> and a.ask_id = f.ask_id(+) > > > This (+) means JOIN Means OUTER JOIN but I don't remember the side. > e.g. (+)-marked equations used as a joining condition Not exactly see above Regards Gaetano Mendola