X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A3C1C3A41A6 for ; Wed, 24 Nov 2004 05:06:54 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 87410-01 for ; Wed, 24 Nov 2004 05:06:43 +0000 (GMT) Received: from web50004.mail.yahoo.com (web50004.mail.yahoo.com [206.190.38.19]) by svr1.postgresql.org (Postfix) with SMTP id 08C993A4246 for ; Wed, 24 Nov 2004 05:06:42 +0000 (GMT) Received: (qmail 86987 invoked by uid 60001); 24 Nov 2004 05:06:41 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=TV9x0ywlsYMXHuIN+A2rSCMtovqsvDbbaBkL57eH65eiYqkDuKiobPEk4VlkitEsxQ5Hq71HLSGWnck94Uhc28M+YpsUjQJGNX46M88hAmsEEaYDaHV/0o6cM2jsiY0viOLa/IBMTl/uja8WCNxFKTDgJ6etzTr1FnUqcPRFR4Y= ; Message-ID: <20041124050641.86985.qmail@web50004.mail.yahoo.com> Received: from [200.93.192.137] by web50004.mail.yahoo.com via HTTP; Tue, 23 Nov 2004 23:06:41 CST Date: Tue, 23 Nov 2004 23:06:41 -0600 (CST) From: Jaime Casanova Subject: Re: joins INNER, OUTER, LEFT, RIGHT, FULL, ... To: pgsql-admin@postgresql.org In-Reply-To: <41A36D7D.7050808@mailporter.net> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/179 X-Sequence-Number: 15562 --- "Roderick A. Anderson" escribió: > Be gentle as I come from an Oracle background a long > time ago. > > I am trying to join several tables with a couple of > tables having a one > to many relationship. I got one query working > pretty well but the issue > comes about when I add one more table with a > one-to-one relationship. I > get a semi/pseudo Cartesian join. > I'm not asking for the exact solution but a pointer > to a _good_ > reference on complex joins. My searching on the > PostgreSQL site and > Google only turn up examples of simple joins. I did > forget to look at > the two PostgreSQL books I have at home -- Bruce's > and Practical > PostgreSQL -- last night so if there are some in > them a light tap with > the clue-stick will suffice. > > http://www.postgresql.org/docs/7.4/static/queries-table-expressions.html#QUERIES-JOIN What do you mean with *complex joins*? regards, Jaime Casanova _________________________________________________________ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com