hmmm, thanks Jon.

How about if I take a different tack, one that I mentioned in the previous note to Andy:

The statement would be simpler if I just selected all records that matched
> hoodfrom == 'SE' (which could include perhaps 25% of all the records in the
> database), then do a 2nd query on the results of this query, and match on
> hoodto == 'NW'.

I'm not sure yet how to query the results of a query, but I'll look into that.

S
--
Stewart Midwinter
stewart@midwinter.ca
stewart.midwinter@gmail.com
Skype, GoogleTalk, iChatAV, MSN, Yahoo: midtoad
AIM:midtoad1