When you want to extract matching records from both the tables, then you use the Inner Join keyword to join those two tables. The following diagram shows the Venn diagram for inner join:
Let's see the script for inner join:
- In the previous application created, comment the existing script.
- Create a new tab and rename it as Inner Join, as shown in the following screenshot. Write the script shown in following screenshot:
- Once you the script is written, click on Load Data to run the script and load the data.
- Once the script is finished, create a new sheet and add the Table object to see the joined table data, as shown in the following screenshot:
