Re: 9/18 Visual Planner Meeting Wrapup

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: len(at)pdx(dot)edu
Cc: "Mark Wong" <markwkm(at)gmail(dot)com>, "Postgresql PDX_Users" <pdxpug(at)postgresql(dot)org>, "David Maier" <maier(at)cs(dot)pdx(dot)edu>
Subject: Re: 9/18 Visual Planner Meeting Wrapup
Date: 2008-10-21 04:29:07
Message-ID: 2E3F62AE-7650-4494-896B-F2097D4D926D@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pdxpug

On Oct 20, 2008, at 20:38, Len Shapiro wrote:

> "Who are the congressional candidates running in my district?"
>
> SELECT candname
> FROM candidate JOIN resident ON candidate.zip = resident.zip
> WHERE resident.name = 'Len Shapiro'

And would that be a join that's not on a foreign key because
candidate.zip and resident.zip are foreign keys to a zip_codes table,
and not otherwise related to one another?

Best,

David

In response to

Responses

Browse pdxpug by date

  From Date Subject
Next Message Chander Ganesan 2008-10-21 11:37:32 Re: Booth Volunteers for LISA 08 (San Diego)
Previous Message Len Shapiro 2008-10-21 03:38:51 Re: 9/18 Visual Planner Meeting Wrapup