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@xxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
