PHWinfo - Afficher un message

31/10/2007, 12h33

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...

31/10/2007, 12h33	#6
houghi Messages: n/a Hébergeur:	Re: Problems working with INNER JOIN 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...