Search for a field with the same informations

Search for a field with the same informations

am 02.01.2008 15:32:58 von tinem

In my table I have a field called "lat" and "lng" which have the coordinates
for showing the markers on my map
http://www.tinemuller.dk/alle_folkebiblioteker/dropdownmenu/ PVII/. The
problem is that some markers are on the same coordinates so I have to figure
out the query to make in Navicat showing this places so I can make a
printscreen to show in the Google Maps forum for further help. Maybe I only
need to search for "lat"?

Can someone help me with this query?

--
M.v.h.
Tine Müller

homepage: http://tine_muller.homepage.dk/

Re: Search for a field with the same informations

am 02.01.2008 17:20:28 von luiheidsgoeroe

On Wed, 02 Jan 2008 15:32:58 +0100, Tine Müller wrote:

> In my table I have a field called "lat" and "lng" which have the
> coordinates
> for showing the markers on my map
> http://www.tinemuller.dk/alle_folkebiblioteker/dropdownmenu/ PVII/. The
> problem is that some markers are on the same coordinates so I have to
> figure
> out the query to make in Navicat showing this places so I can make a
> printscreen to show in the Google Maps forum for further help. Maybe I
> only
> need to search for "lat"?

I'd certainly think you'll have to match them both offcourse.

> Can someone help me with this query?

An SQL group/a group of your specific database flavor seems more
appropriate (if mysql => comp.databases.mysql).
--
Rik Wasmus