Re: A question about Join?...

BTW for those interested Oracle 9i also uses the LEFT, RIGHT, and OUTER join syntax as well.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Stephan Szabo [mailto:sszabo(at)megazone(dot)bigpanda(dot)com]
Sent: Wednesday, June 23, 2004 12:54 PM
To: Jhonatas M. Rodríguez
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] A question about Join?...

On Wed, 23 Jun 2004, [iso-8859-1] Jhonatas M. Rodríguez 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=*field2"
>
> In Oracle the joins are with the simbol (+),
> Example:. the left join is "field1(+)=field2"
>
> 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 = table2.field2)
table2 RIGHT OUTER JOIN table1 ON (table2.field2 = table1.field1)

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)