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
You could always try the LIMIT keyword :)
select a.college, a.state, a.cd http://a.cd/, b.rep from a, b
where
a.state = al and a.cd http://a.cd/ = 3 or
a.state = az and a.cd http://a.cd/ = 1 and
a.state = b.state and
a.cd http://a.cd/ = b.cd http://b.cd/
LIMIT 50
--
Joseph Crawford Jr.
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