How to perform Join operations in Leapwork

In Database testing, a Join clause has a lot of significance since it allows the user to join or combines columns from one or more tables in a relational database.

In Leapwork, user can perform different joins like Inner Join, Left Join, Right Join, Full Join, Cross Join, Self Join etc using the Database building block in the Data-Driven Category.

Note: For using the database block for performing database join, Please make sure that the ODBC DSN is configured for the database, which can be used by the Database block in Leapwork. To know more about this please Click here.

INNER JOIN

The INNER JOIN keyword selects records that have matching values in both tables.

LEFT JOIN

The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). In case of no match, the result is NULL from the right side.

RIGHT JOIN

The RIGHT JOIN keyword returns all records from the right table (table2), and the matched records from the left table (table1). The result is NULL from the left side, when there is no match.

FULL JOIN

A FULL JOIN returns all the rows from the joined tables, whether they are matched or not i.e. you can say a full join combines the functions of a LEFT JOIN and a RIGHT JOIN.

CROSS JOIN

The CROSS JOIN is used to generate a paired combination of each row of the first table with each row of the second table. This join type is also known as cartesian join.

SELF JOIN

The SQL SELF JOIN is used to join a table to itself as if the table were two tables; temporarily renaming at least one table in the SQL statement

For any clarification, please contact our Priority Support.