RE: [PHP-DB] Limiting Results

[Miguel Guirao]

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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Limiting Results

[Joseph Crawford]

You could always try the LIMIT keyword :)

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 

LIMIT 50

-- 
Joseph Crawford Jr.
Codebowl Solutions
[EMAIL PROTECTED]