Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0A110476987; Fri, 17 Jan 2003 12:51:04 -0500 (EST) Received: from fddlnint05.fds.com (fddlnint05.fds.com [208.15.91.52]) by postgresql.org (Postfix) with ESMTP id 3B6D4477416; Fri, 17 Jan 2003 12:43:01 -0500 (EST) Subject: Re: Strange Join question To: "Noah Silverman Cc: pgsql-performance@postgresql.org, pgsql-performance-owner@postgresql.org X-Mailer: Lotus Notes Release 5.0.4 June 8, 2000 Message-ID: From: "Patrick Hatcher" Date: Fri, 17 Jan 2003 09:38:42 -0800 X-MIMETrack: Serialize by Router on FDDLNINT05/FSG/SVR/FDD(Release 5.0.4 |June 8, 2000) at 01/17/2003 12:40:07 PM MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/187 X-Sequence-Number: 834 Can you do select table2.f1, table1.name from table1,table2 where table1.id = table 2.id and table2.id = 2 GROUP BY table2.f1, table1.name; Patrick Hatcher Macys.Com Legacy Integration Developer 415-422-1610 office HatcherPT - AIM Noah Silverman To: pgsql-performance@postgresql.org Sent by: cc: pgsql-performance-owner@post Subject: [PERFORM] Strange Join question gresql.org 01/17/2003 09:28 AM Hi, I have a challenging (for me) SQL question: Two tables (Note: these are fictitious, the real tables actually make sense, so no need to re-design our table structure) Table 1 id | name | count ------------------------ 1 | foo | 10 1 | foo | 20 2 | bar | 100 Table 2 id | f1 | f2 | t1ref ----------------------- 1 | 10 | 20 | 1 2 | 50 | 40 | 2 The question: I want to do the following select: select table2.f1, table1.name from table1,table2 where table1.id = table 2.id and table2.id = 2; The problem is that I really only need the name from table2 returned once. With this query, I get two records back. Clearly this is because of the join that I am doing. Is there a different way to perform this join, so that I only get back ONE record from table1 that matches? Thanks, -Noah ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)