X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id A889A9FB318 for ; Mon, 11 Sep 2006 09:28:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 52719-10 for ; Mon, 11 Sep 2006 12:28:09 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ore.jhcloos.com (ore.jhcloos.com [64.240.156.239]) by postgresql.org (Postfix) with ESMTP id A40989FB252 for ; Mon, 11 Sep 2006 09:28:09 -0300 (ADT) Received: from lugabout.jhcloos.org (ppp30.pm3-14.buf-ch.ny.localnet.com [69.48.14.222]) (using TLSv1 with cipher EDH-RSA-DES-CBC3-SHA (168/168 bits)) (Client CN "lugabout.jhcloos.org", Issuer "ca.jhcloos.com" (verified OK)) by ore.jhcloos.com (Postfix) with ESMTP id BE2C81C57C for ; Mon, 11 Sep 2006 07:27:43 -0500 (CDT) Received: by lugabout.jhcloos.org (Postfix, from userid 500) id DB4CA250292; Mon, 11 Sep 2006 12:05:24 +0000 (GMT) X-Hashcash: 1:23:060911:pgsql-sql@postgresql.org::SoXMDnUEO/judP19:0000000000000000000000000000000000000b4kg From: James Cloos To: pgsql-sql@postgresql.org Subject: Re: where clause subqueries vs multiple rows results In-Reply-To: (James Cloos's message of "Sun\, 10 Sep 2006 23\:27\:59 -0400") References: Copyright: Copyright 2006 James Cloos X-Hashcash: 1:23:060911:cloos@jhcloos.com::KvEAcqWKhn5J9oDh:00000000000000000000000000000000000000000000FbP5 Date: Mon, 11 Sep 2006 08:04:59 -0400 Message-ID: Lines: 13 User-Agent: Gnus/5.110006 (No Gnus v0.6) Emacs/23.0.0 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.134 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/68 X-Sequence-Number: 26279 [SIGH] I was getting the syntax wrong. Just using ON rathar than = fixed the mistake. Time to crash for the night (day?) it seems.... Thanks for the replies; if I hadn't've figured it out myself they would have pushed me in the right direction. -JimC -- James Cloos OpenPGP: 0xED7DAEA6