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: (view raw, whole thread or download thread mbox)
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

I want to continue with the original idea, how i do a
join without 
(table1 LEFT JOIN table2 ON (table1.field1 =
table2 RIGHT OUTER JOIN table1 ON (table2.field2 =

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


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-2017 The PostgreSQL Global Development Group