Rik Wasmus wrote:
>> That works partialy. OK, it work completely, yet I need something a
>> little bit differently. I have stores in "stores" that I do not have in
>> "distance" and thus would not like to see.
>
> And it won't. This query checks for store_id's in distance, and joins
> stores to it.

And it does that perfectly. However I need to exclude some stores.

> If a store_id is not in distance, it will never be a result
> of this query. If you do get a store you don't want, please post some
> sample data and the query used.

Will do later today or tomorrow, when I am at my own PC again and have
more time.

houghi
--
houghi http://houghi.org http://www.plainfaqs.org/linux/
http://www.netmeister.org/news/learn2quote.html
>
> Today I went outside. My pupils have never been tinier...