Continue with the original idea, about JOINS....

From: Jhonatas M(dot) Rodríguez <jhonatas_rod(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Continue with the original idea, about JOINS....
Date: 2004-06-25 21:56:23
Message-ID: 20040625215623.54611.qmail@web14101.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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
"table1.field1 (+)= table2.field2"

What is the simbol the PostgreSQL in the use the
JOINS?....

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 simbol (as (*,+, anything)).

Best regards,

Jhonatas M. Rodríguez

=====
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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-06-25 22:19:07 Re: Continue with the original idea, about JOINS....
Previous Message Naomi Walker 2004-06-25 18:27:03 Sequence Number question