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.
The INNER JOIN keyword selects records that have matching values in both tables.
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.
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.
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.
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.
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.