in access, the following SQL oughta show up the records that are in your funky table but not in costar.
################## SELECT * FROM Funky LEFT JOIN CoStar ON Funky.Address = CoStar.Address WHERE CoStar.Address Is Null; ################## you can then plow through them altering the funky items to fit existing stuff within the costar table. an option which might help here is to make up some queries which apply a bit of fuzzy logic to selecting them. this will involve black magic and InStr and InStrRev and long ugly equations with Left$ and Right$ featuring predominantly. let us know if it needs more input. -----Original Message----- From: Jennifer Blek [mailto:[EMAIL PROTECTED] Sent: Friday, 12 December 2003 7:00 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: MI-L Access & MapInfo Hi, all !!! I'm adjusting an Access database, but doing most of the table work in MapInfo. I have two tables. One has CoStar addresses (40 character column) and a unique ID for each address name. The second has different IDs and buildings with addresses (40 character column) that are usually identical to CoStar, but occasionally they're different (e.g. Conn instead of Connecticut, 815 Fairfax instead of 815-817 N Fairfax). I found as many as I could and replaced them with CoStar addresses, but there are 3,500 buildings, and I don't want to spend too much time on it. What I want to be able to do is to identify all objects (funky addresses) in the the second table that aren't objects (CoStar addresses) in the first table. That way I can change the funky ones to fit their CoStar counterparts. The problem is that the tables aren't geocoded and can't be. Have any ideas on the query to do this in MapInfo or Access? Also, how long should a query like that take? Jennifer Blek GIS Manager STUDLEY 10960 Wilshire Blvd., Suite 1700 Los Angeles, CA 90024 Phone: 310 444-1013 Fax: 310 444-1099 _________________________________________________________________ Get holiday tips for festive fun. http://special.msn.com/network/happyholidays.armx --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9533 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9541
