Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 56D759F9ED6 for ; Tue, 21 Aug 2007 16:19:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 79748-01-4 for ; Tue, 21 Aug 2007 16:18:59 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web31802.mail.mud.yahoo.com (web31802.mail.mud.yahoo.com [68.142.207.65]) by postgresql.org (Postfix) with SMTP id B4B349F9B94 for ; Tue, 21 Aug 2007 16:18:53 -0300 (ADT) Received: (qmail 59412 invoked by uid 60001); 21 Aug 2007 19:18:52 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=pxIpp6o1m6q5YyHA7RYr6wKdebVSbsm06m6hrTd66Cyg49IvhYFo4Yc6BIKJjlQh0Qwxu34KU+flA8B56+c/2nv2NsnAAAAZAPbbulCqgLj6+UKv1yBFCrXUkJmNR8thyoHGqNj9nalxCamdY6FAhtsLR58aM69XdGQKQV+hqxs=; X-YMail-OSG: KNHqUgsVM1mRfO4CwXpAbIkoLBqbWopiCuZ9TwuHD92XcQvKLYUJegdTiY56J9LPWA-- Received: from [12.180.237.138] by web31802.mail.mud.yahoo.com via HTTP; Tue, 21 Aug 2007 12:18:52 PDT Date: Tue, 21 Aug 2007 12:18:52 -0700 (PDT) From: Richard Broersma Jr Subject: Re: Join question To: Richard Broersma Jr , tyrrill_ed@emc.com, pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <663038.58978.qm@web31802.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/170 X-Sequence-Number: 29108 oops... I meant "DISTINCT ON ( a_id )" --- Richard Broersma Jr wrote: > SELECT a.x, b.x > FROM ( SELECT DISTINCT ON ( a_id ) a_id, b_id ^^ > FROM c ) AS c( a_id, b_id ) > INNER JOIN a > ON c.a_id = a.id > INNER JOIN b > ON c.b_id = b.id; > > Regards, > Richard Broersma Jr. > > > >