Re: [GENERAL] Doubt about join clause

2009-04-20 Thread Sam Mason
On Mon, Apr 20, 2009 at 08:02:49PM -0400, David Wilson wrote: > On Mon, Apr 20, 2009 at 7:39 PM, jc_mich wrote: > > You've understood very well my problem, but also this query works as worse > > than everything I did before, it throws as many rows as rows are contained > > my tables clients and st

Re: [GENERAL] Doubt about join clause

2009-04-20 Thread David Wilson
On Mon, Apr 20, 2009 at 7:39 PM, jc_mich wrote: > > You've understood very well my problem, but also this query works as worse > than everything I did before, it throws as many rows as rows are contained > my tables clients and stores. I only want to find for every client what > store is closer to

Re: [GENERAL] Doubt about join clause

2009-04-20 Thread jc_mich
You've understood very well my problem, but also this query works as worse than everything I did before, it throws as many rows as rows are contained my tables clients and stores. I only want to find for every client what store is closer to him, I expect one client to one store and their distance

Re: [GENERAL] Doubt about join clause

2009-04-20 Thread Bill Moran
In response to jc_mich : > > Hello > > I have a table with clients and other with stores, I want to calculate > minimum distances between stores and clients, the client name and its closer > store. > > At this moment I can only get clients ids and minimum distances grouping by > client id, but w