| Miguel Guirao 2005-05-19, 3:56 pm |
| I believe you need a main table where youn list all the colleges with
columns for STATE, CONGRESSIONAL DISTRICT and REPRESENTATIVE.
And those three columns would be pulled from three table catalogs: STATES,
CONGRESSIONAL DISTRICTS and REPRESENTATIVES.
Maybe there is a better approach, but I don't know the way your states or
country is organized.
Miguel
-----Original Message-----
From: kc68@cornell.edu [mailto:kc68@cornell.edu]
Sent: Jueves, 19 de Mayo de 2005 07:13 a.m.
To: php-db@lists.php.net
Subject: [PHP-DB] Limiting Results
I am trying to limit results pulled from two tables, each with all states
and
congressional districts, to specified congressional districts. I want
each college to
appear once matched to each congressional district (that is in one table
and is easy to do)
and also include a column from a second table with the Representative. My
syntax, below,
produces far too many results, matching college and district and
Representative many times.
The syntax:
select a.college, a.state, a.cd, b.rep from a, b
where
a.state = "al" and a.cd = "3" or
a.state = "az" and a.cd = "1" and
a.state = b.state and
a.cd = b.cd
What do I do to limit to single match for each college in the specified
congressional
districts?
Ken
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
|