In answer to a posting a while ago, I thought I'd share a trick I just confirmed would work, although hadn't bothered to try it before. It is useful if you want to do either a left join of two tables or delete records in one table that do not occur in another - something that was on the list recently. If you use table > update column and join two tables by their index (common) field, add a temporary column to the first that is the index field of the second, you get all the records in the first table, and data in the temporary column of the first table for the records where the index field occurs in the second, viz, a left join - albiet one field. Now if you select the records where the temporary column is null, then you are selecting those records in the second table that do not have a corresponding record in the first. R Robert Crossley Wild Lime Suite 1, 169 Newell St CAIRNS 4870 AUSTRALIA Ph: 61-7-40337644 [EMAIL PROTECTED] ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
