Обсуждение: A question about Join?...
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
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)
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)