Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group