Cool. I need it all in one row, so I can refer to it as QueryName.Capital, QueryName.Largest.
Chad On 7/7/05, Mark Mandel <[EMAIL PROTECTED]> wrote: > 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/ > --- 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/
