INNER JOIN 

A JOIN clause is used to combine rows from two or more tables, based on a related column between them.

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


Syntax:

SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;

Query:

SELECT employees.emp_no, employees.last_name, employees.first_name, salaries.salary 
FROM `employees` INNER JOIN salaries ON employees.emp_no=salaries.emp_no


Output
:

Inner Join Example

Tester Usage Tips:

  • Validate records from more than 1 table with the exact match conditions of records from all table records for example all tests taken by a logged in user with joining user id for users and tests table