Dear list,

When I make a SQL join like:

SELECT * 
FROM MI_table, RDBMS_table
WHERE MI_table.id = RDBMS_table.id
INTO new_table

and add new_table to the map, I sometimes get odd results with the Info
Tool. This behaviour occurs when the RDBMS_table contains two records with
the same id (e.g. two owners of a building). The Info Tool displays two
identical records, but new_table contains two different records from the
RDBMS_table joined to one object.

Can anyone tell me how to get this to work properly?


TIA

S�ren Breddam



_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.

Reply via email to