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])