I have 2 tables say A and B. Table has a number columns including name.Table A has 10 names.Table B is a referencelist which has 1000 names and corresponding ages. Is there a way to join the 2 tables so that the new joined table has only 10 names from Table A and respective ages from Table B?
when I tried this , got an error saying columns do not match.
will do exactly this. Just select the columns you want to match on, and then select to "Include non-matches" for the main table(your table with 10 names). The resulting table will have only your 10 names.
If you look at my last response, you will see that one of the selections I made on the Dialog for the Join Platform, is called "Merge same name columns". This will match names.
If you open up the Tables==>Join dialog, you can click on the "Help" button and it will display information about all of the selections and settings availabel to the platform. You need to familiarize yourself with the Help environment. It is a very quick and easy way to learn all about any of the platforms.