I have 2 MapInfo tables that have a corresponding unique ID number field. I'd like to be able to manually select some objects from one table and join the 2 tables based on a matching unique ID number for the selected objects only.
Is this possible?
Yes, this is possible.
You do it like regular SQL, but use the MapInfo user interface.
Here's an example: http://web.pb.com/mapinfopro-sep-2012/Query-Ninja-Joining-Tables
And here's an image showing how (from the above URL).
EDIT:
In order to achieve the result you're after, try these steps:
- First join the two tables together by selecting * for 'select columns' your two tables in the 'from tables' and setting table1.id = table2.id (where table and id are replaced by actual values) in the 'where condition' field.
- If step 1 works, you should see a table with all the info you're after and you can do a select from this table to get your 20 records.
- Once step 2 works, you may like to revisit step one to do it all in one go!
-
Thank you Alex, I'm struggling to apply this methodology to my query though. I'll provide a little more detail. Table A and Table B have objects with a matching unique ID number. Table A contains 100 records with owner and address information. Table B contains 50 records with a property ID number. I want to select for example 20 records from Table B and join the 20 selected records to the 20 matching records in Table A. The result would be a table with 20 records containing the owner & address records from Table A and the property ID number from Table B. – Craig T Nov 9 '16 at 21:42
-
You can definitely do this, @CraigT. I don't have a copy of MapInfo currently, so I can't work the example fully. You can do it in stages, though, which should be easy. I'll edit my answer with a suggestion. – Alex Leith Nov 9 '16 at 22:46
-
