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:[EMAIL PROTECTED] Sent: Wednesday, June 23, 2004 12:54 PM To: Jhonatas M. Rodríguez Cc: [EMAIL PROTECTED] 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 [EMAIL PROTECTED]) ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])