X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C66BA9FA621 for ; Sun, 9 Jul 2006 02:56:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 83398-03-6 for ; Sun, 9 Jul 2006 02:56:27 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31809.mail.mud.yahoo.com (web31809.mail.mud.yahoo.com [68.142.207.72]) by postgresql.org (Postfix) with SMTP id 85D649FA60C for ; Sun, 9 Jul 2006 02:56:27 -0300 (ADT) Received: (qmail 91292 invoked by uid 60001); 9 Jul 2006 05:56:26 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=20Yr/ZvZzwDSEacol1rF8MOX+dqIhxOMbIOJjRF1o7OWwHaLmQU+Onjoa8aV4lGfYtPO/5d1dIr2grzeqm++T25RQWzFtwvdq6S1IIAnq/e8aBhv44Bg2X9RU7mI9S6dZ6nRD06toDaDhZPCkoYABmgKFFp+AZkjxO1SI3E6fJM= ; Message-ID: <20060709055626.91290.qmail@web31809.mail.mud.yahoo.com> Received: from [24.54.196.198] by web31809.mail.mud.yahoo.com via HTTP; Sat, 08 Jul 2006 22:56:26 PDT Date: Sat, 8 Jul 2006 22:56:26 -0700 (PDT) From: Richard Broersma Jr Subject: Re: table joining duplicate records To: onin Cc: SQL Postgresql List In-Reply-To: <44B08B5C.5050901@mobius.ph> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/137 X-Sequence-Number: 25711 > can i have a result set. just like the outer join returns. > but on my case. return null on duplicates. > like this one. > > survey :category :question :answer > ----------------------------------- > survey1:category1:question1:answer1 > : : :answer2 hmmm.. I am no sure that you are going to get what you want from a simple select query. A reporting software could do this easily however. also be sure to include the list in your replies :-). Regards, Richard Broersma Jr.