Yeah - that's what I was going to say -
Select
state.name,
largest.name as largestName
capital.name as capitalName
from
state,
city largest,
city capital
where
state.idstate = largest.lnkIDCity
AND
state.idstate = capital.lnkIDCity
AND
largest.isLargest = 1
AND
capital.isCapital = 1
There is a list for all, I'm sure you can narrow it down to one state
if you want.
Why bother with 2 rows, when one will do? (or a union for that matter)
On 7/7/05, Jon Austin <[EMAIL PROTECTED]> wrote:
> Can't you join the two tables in the query?
--
E: [EMAIL PROTECTED]
W: www.compoundtheory.com
ICQ: 3094740
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
