I keep getting "No join specified between Table1 and Table2. Invalid join
condition in WHERE clause" when trying to run the example below. Does
anyone have any ideas?
Rowland
Joining Tables By The Order Of The Rows
If two tables do not share a common column, you may still be able to join
the tables according to the order of the rows. If you know that the first
row of one table corresponds to the first row of the other table and, in
general, if you know that the Nth row of the first table corresponds to the
Nth row of the second table, you can join the two tables by referring to a
special column named RowID.
The RowID column contains an integer value, representing the row number of
each row in the table. Thus, the first row in any table has a RowID value of
one, the second row has a RowID value of two, etc.
To join two tables so that MapInfo matches the Nth row of one table to the
Nth row of the other table, specify a Where Condition expression of this
form:
Where Condition: TABLE_1.RowID = TABLE_2.RowID
See Also ...
SQL Select
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
