| From: | Robby Russell <robby(at)planetargon(dot)com> |
|---|---|
| To: | Hrishikesh Deshmukh <hdeshmuk(at)gmail(dot)com> |
| Cc: | Postgresql-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: GUI |
| Date: | 2005-03-03 23:53:22 |
| Message-ID: | 1109894002.10597.24.camel@linus |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 2005-03-03 at 18:00 -0500, Hrishikesh Deshmukh wrote:
> Hi,
> I want to do a 17 table join! :( But a general idea will help.
>
> Thanks,
> H
Try here to start:
http://www.postgresql.org/docs/current/static/tutorial-join.html
> SELECT *
> FROM weather LEFT OUTER JOIN cities ON (weather.city = cities.name);
Cheers,
Robby
--
/***************************************
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | robby(at)planetargon(dot)com
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting & Development
* --- Now hosting Ruby on Rails Apps ---
****************************************/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew Schumacher | 2005-03-03 23:58:51 | Running queries or functions stored in a table. |
| Previous Message | Scott Frankel | 2005-03-03 23:51:24 | preserving data after updates |