|
I am trying to join two tables in MapInfo where there isn’t
a column-to-column match. In Oracle SQL I can do a join on substrings of a
panel or on a joint _expression_ of two columns matched to one. However, when I try
this in MapInfo it gives me an error about my join not being valid. Table1 cmtyno (char 6) = Table2 state
(char 2) + Table2 community (char 4). So I try this as my join: Table1.cmtyno = (Table2.state+Table2.community) MapInfo throws me an error saying it’s an invalid
join. Then I try this as my join: Right$(Table1.cmtyno,4) =
Table2.community This also causes MapInfo to give me and error about an
invalid join. Is it possible to join these two tables without creating new
columns? Am I just getting my syntax wrong or have I found a limitation in
MapInfo? -Evan MacDougall GIS Supervisor Nationwide TotalFlood Services Inc. (NTSI) (a wholy owned subsidiary of Capital Title Group) (800)736-3109 x3681 "Gentlemen, we may not make history tomorrow, but we
shall certainly change the geography." |
_______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
