pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedA question about Join?...
3+ messages / 3 participants
[nested] [flat]
* A question about Join?...
@ 2004-06-23 16:11 Jhonatas M. Rodríguez <jhonatas_rod@yahoo.com>
2004-06-23 16:53 ` Re: A question about Join?... Stephan Szabo <sszabo@megazone.bigpanda.com>
0 siblings, 1 reply; 3+ messages in thread
From: Jhonatas M. Rodríguez @ 2004-06-23 16:11 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: A question about Join?...
2004-06-23 16:11 A question about Join?... Jhonatas M. Rodríguez <jhonatas_rod@yahoo.com>
@ 2004-06-23 16:53 ` Stephan Szabo <sszabo@megazone.bigpanda.com>
0 siblings, 0 replies; 3+ messages in thread
From: Stephan Szabo @ 2004-06-23 16:53 UTC (permalink / raw)
To: Jhonatas M. Rodríguez <jhonatas_rod@yahoo.com>; +Cc: pgsql-admin
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)
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: A question about Join?...
@ 2004-06-23 17:24 Goulet, Dick <DGoulet@vicr.com>
0 siblings, 0 replies; 3+ messages in thread
From: Goulet, Dick @ 2004-06-23 17:24 UTC (permalink / raw)
To: pgsql-admin
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@megazone.bigpanda.com]
Sent: Wednesday, June 23, 2004 12:54 PM
To: Jhonatas M. Rodríguez
Cc: pgsql-admin@postgresql.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@postgresql.org)
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-06-23 17:24 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-23 16:11 A question about Join?... Jhonatas M. Rodríguez <jhonatas_rod@yahoo.com>
2004-06-23 16:53 ` Stephan Szabo <sszabo@megazone.bigpanda.com>
2004-06-23 17:24 Re: A question about Join?... Goulet, Dick <DGoulet@vicr.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox