Discussion:
A question about Join?...
(too old to reply)
Jhonatas M. Rodríguez
2004-06-23 16:11:33 UTC
Permalink
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?....



Best regards,

Jhonatas M. Rodríguez

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)
Stephan Szabo
2004-06-23 16:53:48 UTC
Permalink
Post by Jhonatas M. Rodríguez
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 ***@postgresql.org)
Goulet, Dick
2004-06-23 17:24:29 UTC
Permalink
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:***@megazone.bigpanda.com]
Sent: Wednesday, June 23, 2004 12:54 PM
To: Jhonatas M. Rodríguez
Cc: pgsql-***@postgresql.org
Subject: Re: [ADMIN] A question about Join?...
Post by Jhonatas M. Rodríguez
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 ***@postgresql.org)

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