Re: [ADMIN] Continue with the original idea, about JOINS....

2004-06-25 Thread Sam Barnett-Cormack
On Fri, 25 Jun 2004, [iso-8859-1] Jhonatas M. Rodríguez wrote: > Thank you at all for yours request > > > >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 > "table1.field1 =* table2.fiel

Re: [ADMIN] Continue with the original idea, about JOINS....

2004-06-25 Thread Stephan Szabo
On Fri, 25 Jun 2004, [iso-8859-1] Jhonatas M. Rodríguez wrote: >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 > "table1.field1 =* table2.field2" > > In Oracle the joins are with the si

Re: [ADMIN] Continue with the original idea, about JOINS....

2004-06-25 Thread Tom Lane
"=?iso-8859-1?q?Jhonatas=20M.=20Rodr=EDguez?=" <[EMAIL PROTECTED]> writes: > I want to continue with the original idea, how i do a > join without > (table1 LEFT JOIN table2 ON (table1.field1 = > table2.field2) > table2 RIGHT OUTER JOIN table1 ON (table2.field2 = > table1.field1)) > else with a sim

[ADMIN] Continue with the original idea, about JOINS....

2004-06-25 Thread Jhonatas M. Rodríguez
Thank you at all for yours request 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 "table1.field1 =* table2.field2" In Oracle the joins are with the simbol (+), Example:. the left join is "