Thread: Graphical SQL builder: JOINS?

Graphical SQL builder: JOINS?

From
jdvoracek
Date:
Hello. I am a part-time SQL user, and in years past I think I remember the
ACCESS graphical tool making it easy to specify LEFT or RIGHT joins.  Is
this not possible with the pgadmin tool, or am I doing it incorrectly?  The
join selections (+,>=, etc.) translate to WHERE, and that has me a bit lost
too although I think a where equal would be equivalent to a simple join. 
Thanks and sorry for the dumb question: I have searched!

-John

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Graphical-SQL-builder-JOINS-tp5477230p5477230.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.


Re: Graphical SQL builder: JOINS?

From
Guillaume Lelarge
Date:
On Sun, 2012-02-12 at 12:05 -0800, jdvoracek wrote:
> Hello. I am a part-time SQL user, and in years past I think I remember the
> ACCESS graphical tool making it easy to specify LEFT or RIGHT joins.  Is
> this not possible with the pgadmin tool, or am I doing it incorrectly?

No, you're right.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com