When you want to extract all the records from the left table and matching records from the right table, then you use the Left Join keyword to join those two tables. The following diagram shows the Venn diagram for left join:
Let's see the script for left join:
- In the previous application created, delete the Outer Join tab.
- Create a new tab and rename it as Left Join, as shown in following screenshot. Write the script shown in the 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:
