Ian,
If I remeber correctly, back in version 2.x or 3.0 of MapInfo there used to
be a Join option on the menu. That made things easy for those not too
familiar with SQL, but wanting to do what you ask. Alas, no more simple join
button, so you use and SQL query.
1. Open your Excel table and save a copy. Open the copy and the polygon
table
2. Make sure the 2 columns which have the field number are the same type
(text, integer, float, etc)
3. Choose from the menu, Query > SQL Select
4. Imagine you have the two table called "Polygons" and "Details" and the
common fields (columns) are called "Numbers" in each table, fill out the SQL
dialog as such:
Select columns: *
>From tables: Polygons,Details
Where condition: Polygons.Numbers=Details.Numbers
5. Leave everything else blank / as is and click OK.
6. You will now have a new table called "Selection" or say "Query1" with the
joined tables. Save a copy.
Hope this helps
(ahhh for a join button or wizard...)
Chris Perry
Manager Mapping Systems
Parks Victoria
Ph: 613 9816 6800
Fax: 613 9816 7222
Email:[EMAIL PROTECTED]
-----Original Message-----
From: Ian Macey [mailto:[EMAIL PROTECTED]]
Sent: Monday, 1 February 1999 23:44
To: MI List
Subject: MI Joining tables
Hello all
I have created a layer which consists of approximately 50 polygons which
represent field boundaries. Associated with this are the field numbers.
I have just received a schedule in excel format which contains all of the
contact details and land ownership. A common column of field numbers exists
between the two.
Could someone please advise me on the best way to combine the two so that
the mappable layer includes all of the contact details etc.
I have used table - update for each of about 15 columns to do this
previously which seems a rather long winded method.
I am rung Map Info Pro V5.0 without MB.
Any help would be much appreciated.
Apologies for the simplistic nature of the query (I am determined to use
MapInfo for more than just creating maps and am only really starting!)
Ian Macey
Dreweatt Neate
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [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]
