Hi Listers - I'm sure this is a 'newbie' question, but as a neophyte, I feel justified in asking it... I did, by the way, refer to the manual, but am unable to locate the right info. I have a table of food-insecure households in East Timor, a place that is much in the news nowadays. I need to join this to boundary data contained in another table. Both the boundary and food-insecurity data are at the spatial resolution of villages. The problem arises in that there are several instances of villages having identical names. This difficulty is resolvable in that the same-name villages are located in different subdistricts, and each of the tables to be joined has a subdistrict column. The hand-holding I need now regards how to join the tables based on matching two, rather than one, columns. The only 'join' tool I'm familiar with is SQL-select, but this doesn't seem to have the ability to match across more than one column. I'm beginning to think the task is a little more complex than it first appears. One other question: which column would it be better to use to make the initial match? If 'subdistrict,' there would be many initial identical matches. Thanks for the pointers! Cheers, Len Milich, Ph.D. United Nations Support Facility for Indonesian Recovery United Nations Building Jalan MH Thamrin 14 Jakarta Pusat, Indonesia (+62) 21 314-1308 extension 215 (+62) 21 392-1152 (fax) ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
