In MariaDB database, JOINS are used to retrieve data from multiple tables. It is performed when we have two or more than two tables.
There are three types of JOINS in MariaDB:
MariaDB INNER JOIN
MariaDB INNER JOIN is the most common type of join which returns all rows from multiple tables where the join condition is satisfied.
We have two tables "Students" and "Employee2".
Use the following syntax to join both table according to given parameters:
You can combine as many fields as you want. Let?s add some more fields: