I have two tables. Table A has 300 records. Table B basically contains same
information as Table A except it has updated information in one of the fields
(field X) and only contains 100 records that were updated, the remaining 200
records in Table A were not updated and are not included in Table B. I would
like to update the field X in Table A using the information in Table B. But
when I try to use the Update Column, I select Table A as the table to be updated
, I choose field X as the field that needs to be updated, then select Table B as
the table to get the value with the field X (tableB) that has the updated
information and JOIN using a key field. What happens is that it will update
the appropriate records in Table A and use the values from Table B (which is
good) however it deletes all the other data for that field for the remaining 200
records in Table A that are not included in Table B. How can I update a field
in Table A with data from Table B and not have the remaining data (for 200
records) deleted in Table A for that field! I hope that makes sense!
Dan
_______________________________________________________________________
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.
