Hey everyone, I have got a simple yet odd question for you. I have two tables: a "Navigation table" with Date, Time, Long and Lat and a "Site table" with Date, Time, and an empty Long and Lat. I want to update the Site table (Long and Lat) with the Navigation table (Long and Lat) where the Navigation.date = the Site.date and the Navigation.time = the Site.time. I know this can be easily done with the SQL select but it is really slow. If it could be done with "update column" I am sure there would be less processing time. Is this type of update column even possible? Of course, I am using MapBasic so if anyone has an example of code to help me out I would be very grateful. Thanks for your time, James Mazur GIS Telecom. Specialist Montreal, Canada [EMAIL PROTECTED] _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
