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?
In response to
pdxpug by date
|Next:||From: Chander Ganesan||Date: 2008-10-21 11:37:32|
|Subject: Re: Booth Volunteers for LISA 08 (San Diego)|
|Previous:||From: Len Shapiro||Date: 2008-10-21 03:38:51|
|Subject: Re: 9/18 Visual Planner Meeting Wrapup|