Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 2653B633547 for ; Fri, 2 Oct 2009 03:36:22 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 45638-04 for ; Fri, 2 Oct 2009 06:36:08 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.188]) by mail.postgresql.org (Postfix) with ESMTP id 2F3C8632F7F for ; Fri, 2 Oct 2009 03:36:11 -0300 (ADT) Received: from webserv.wug.de ([194.25.154.138]) by mrelayeu.kundenserver.de (node=mreu2) with ESMTP (Nemesis) id 0MCMWT-1N2AKs2HGD-008ou5; Fri, 02 Oct 2009 08:36:09 +0200 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1MtbkM-0007cM-00; Fri, 02 Oct 2009 08:36:06 +0200 Date: Fri, 2 Oct 2009 08:36:06 +0200 From: "A. Kretschmer" To: Greenhorn , pgsql-sql@postgresql.org Subject: Re: right join problem Message-ID: <20091002063606.GC22496@a-kretschmer.de> References: <20091002054548.GB22496@a-kretschmer.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-OS: Debian/GNU Linux - weil ich es mir Wert bin! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX1/PuQyKK2LVsvYWRXNZliSvym/OoamWptrfwUX /Bc/HjEysDArEXooyDZijsQz4t/bqtNDx6sFfBHVnHmiE7GTiR s0R6QUGx+F2Przl9RirdA== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.084 tagged_above=-10 required=5 tests=AWL=-0.899, BAYES_40=-0.185 X-Spam-Level: X-Archive-Number: 200910/12 X-Sequence-Number: 33211 In response to Greenhorn : > > > > Use a left join instead? > Hi, > Yes, but when i use a where clause on my query it only selects joined > records. :( > Thanks. Please, answer to the list and not directly to me. The WHERE-Clause works after the JOIN - so your select contains (without the WHERE) all rows. Maybe i don't understand you, can you show a simple example with data? Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)