Thanks a lot! It works as good as I wish
Best regards.
Michael Nolan wrote:
>
> On Tue, Apr 21, 2009 at 12:04 PM, jc_mich wrote:
>
>>
>> The problem is not the formula, the problem is the join. I've summarized
>> it
>> because is a large formula and I've got right results
>>
>>
> You're quit
On Tue, Apr 21, 2009 at 12:04 PM, jc_mich wrote:
>
> The problem is not the formula, the problem is the join. I've summarized it
> because is a large formula and I've got right results
>
>
You're quite correct that the problem is the join, because neither of the
examples you gave have any code to
The problem is not the formula, the problem is the join. I've summarized it
because is a large formula and I've got right results
Here is the complete code code, stores and clients have a longitude and
latitude, and ponderator is a demand variable:
SELECT distances.client_id, min(distances.dist)
2009/4/20 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 when I
