Re: Doubt about join queries

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 <juan.michaca@paasel.com> 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 limit the number of store records
> returned.
>
> You may need to include something like the following code fragment.  (I'm
> using a 'distance' formula as a proxy for the latitude/longitude formula.)
>
> where store_no = (select store_no from store order by
> distance(store,customer) limit 1)
> --
> Mike Nolan
>
>

--
View this message in context: http://www.nabble.com/Doubt-about-join-queries-tp23142980p23160612.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.