I have a table with four columns as follows : Code Name Type Postcode
It has approx 1900 points. I want to write an SQL query that takes each point in the table and compares it with every other point in the table and creates a new table where the distance between any two points is less than 20 miles. I am sure this is possible (and I think I will need two copies of the table to perform this query) but I am very new to Mapinfo and still learning! Any help would be greatly appreciated.
