From: | "Roderick A(dot) Anderson" <raa(at)mailporter(dot)net> |
---|---|
To: | PgSQL ADMIN <pgsql-admin(at)postgresql(dot)org> |
Subject: | joins INNER, OUTER, LEFT, RIGHT, FULL, ... |
Date: | 2004-11-23 17:03:57 |
Message-ID: | 41A36D7D.7050808@mailporter.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Be gentle as I come from an Oracle background a long time ago.
I am trying to join several tables with a couple of tables having a one
to many relationship. I got one query working pretty well but the issue
comes about when I add one more table with a one-to-one relationship. I
get a semi/pseudo Cartesian join.
I'm not asking for the exact solution but a pointer to a _good_
reference on complex joins. My searching on the PostgreSQL site and
Google only turn up examples of simple joins. I did forget to look at
the two PostgreSQL books I have at home -- Bruce's and Practical
PostgreSQL -- last night so if there are some in them a light tap with
the clue-stick will suffice.
Thanks,
Rod
--
---
[This E-mail scanned for viruses by Declude Virus]
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Hoover | 2004-11-23 21:06:52 | problems with authentication |
Previous Message | Pete..... | 2004-11-23 17:03:35 | Transfer data from webpage form to database |