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 0D46DD1B173 for ; Wed, 23 Jun 2004 13:53:59 -0300 (ADT) 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 15814-04 for ; Wed, 23 Jun 2004 16:53:51 +0000 (GMT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 2443DD1B33D for ; Wed, 23 Jun 2004 13:53:49 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id EF7ED350F7; Wed, 23 Jun 2004 09:53:48 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id ED67D350DD; Wed, 23 Jun 2004 09:53:48 -0700 (PDT) Date: Wed, 23 Jun 2004 09:53:48 -0700 (PDT) From: Stephan Szabo To: "=?iso-8859-1?q?Jhonatas=20M.=20Rodr=EDguez?=" Cc: pgsql-admin@postgresql.org Subject: Re: A question about Join?... In-Reply-To: <20040623161133.3797.qmail@web14105.mail.yahoo.com> Message-ID: <20040623095054.K55447@megazone.bigpanda.com> References: <20040623161133.3797.qmail@web14105.mail.yahoo.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=iso-8859-1 Content-Transfer-Encoding: QUOTED-PRINTABLE 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: 200406/311 X-Sequence-Number: 13971 On Wed, 23 Jun 2004, [iso-8859-1] Jhonatas M. Rodr=EDguez wrote: > Hello Everybody?... > > > > Hey, i have a question about of the uses the joins > in PostgreSQL. > > In SQL Server the joins i can use with the simbol(*), > Example:. the right join is "field1=3D*field2" > > In Oracle the joins are with the simbol (+), > Example:. the left join is "field1(+)=3Dfield2" > > What is the simbol the PostgreSQL in the use the > JOINS?.... PostgreSQL uses the SQL standard syntax for outer joins. Things like: table1 LEFT JOIN table2 ON (table1.field1 =3D table2.field2) table2 RIGHT OUTER JOIN table1 ON (table2.field2 =3D table1.field1)