Hi Frank, There's no immidiate "closest match" functionality in MIPro. And thus no simple way to achieve what you ask for.
But if you change table 1 (= Points1) to instead of point objects to contain the "nearest neighbourhood" (aka Voronoi/Thiessen polygons) around the points, it would be a simple geographic join: Table2.OBJ Within Table1.OBJ Voronoi polygons may be constructed in MIPro 7.0. Or for non-7.0 users, using one of several add-on tools, e.g. Vertical Mapper. There might even some shareware/freeware around ? Best regards/Med venlig hilsen Lars V. Nielsen GisPro, Denmark http://www.gispro.dk/ http://hjem.get2net.dk/lars-online/ WGS84: 10.20'40"E 55.20'20"N ----- Original Message ----- From: "Brancato, Frank" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 26, 2002 8:08 PM Subject: MI-L I need an SQL Expert for comparing two points > Hello, > > I am not that proficient with SQL Select syntax. I am in desperate need of > a Query to compare two tables points and find the closest match based on > distance. > > Basically I have two tables: Points1.tab & Points2.tab. I want to populate > an empty column in Points2 table with data from Points1 that is as close as > possible in Distance. > > Points1 Points2 > LON LAT Freq LON LAT Empty column to > Populate with Freq > > > Thanks in advance > Frank > > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 4285
