I have two point tables, each with occurences of the same (duplicate) data, held in two columns. How can I get MI to select these instances of duplication (querying the 2 tables and the respective columns simultaneously) so that they can be removed? In both tables, each point record represents an address with column one holding the house number and column three the street name. I need to remove all instances of duplication across these two columns, i.e where house number and street name appear in each individual table. Any advice on how to find these duplicates would be appreciated. [EMAIL PROTECTED] Dr Conor G. Smyth Operations Information Systems Co-ordinator GISTRAN Translink Central Station, East Bridge Street, Belfast BT1 3PB Direct Telephone: (028) 90899464 or Internal Ext. 2284 Fax: (028) 90899401 ********************************************************************** This e-mail and any attachments are strictly confidential and intended solely for the addressee. They may contain information which is covered by legal, professional or other privelege. If you are not the intended addressee, you must not copy the e-mail or the attachments, or use them for any purpose or disclose their contents to any other person. To do so may be unlawful. If you have received this transmission in error, please notify the sender as soon as possible and delete the message and attachments from all places in your computer where they are stored. Please be aware that e-mail is not a secure form of communication. Messages sent via this medium may be subject to delays, non-delivery and unauthorised access. Although we have scanned this e-mail and any attachments for viruses, it is your responsibility to ensure that they are actually virus free. ********************************************************************** _______________________________________________________________________ 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.
