Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pdxpug by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group