When you want to extract all the records from the right table and the matching records from the left table, then you use the right join keyword to join those two tables. The following diagram shows the Venn diagram for right join:

Let's see the script for right join:

1. In the previous application created, comment the existing script.
2. Create a new tab and rename it as Right Join, as shown in the following screenshot. Write the script, as shown in the following screenshot:

3. Once you the script is written, click on Load Data to run the script and load the data.
4. 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: