| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Jhonatas M(dot) Rodríguez <jhonatas_rod(at)yahoo(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: A question about Join?... |
| Date: | 2004-06-23 16:53:48 |
| Message-ID: | 20040623095054.K55447@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris White (cjwhite) | 2004-06-23 17:11:45 | Problems restoring tables using 7.4.2 |
| Previous Message | Jhonatas M. Rodríguez | 2004-06-23 16:11:33 | A question about Join?... |