Chris Perry had a very detailed answer to the question (quoted below) but
to take his approach one step further - Create a text file generally like
the following:
!Table
!Version 100
Open Table "Parcel"
Open Table "Tax_Roll"
Create View Ownership As
Select *
>From Tax_Roll, Parcel
Where Tax_Roll.PIDN=Parcel.PIDN
And save it with a name like "Join.tab". Then you can maintain the spatial
and attribute files independently. This is quite handy if you get updates
from another agency. You can accomplish the same thing with Chris's
approach (using SELECT, rather than CREATE VIEW) and save it to a
workspace, but I have found that the performance of SELECT saved in a
workspace is much slower than a CREATE VIEW saved as a tab file.
Rich
>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
Richard W. Greenwood, PLS
Greenwood Mapping, Inc.
[EMAIL PROTECTED]
(307) 733-0203 fax: 733-4018
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
