MariaDB INNER JOIN is the most common type of join which returns all rows from multiple tables where the join condition is satisfied.

Syntax:

SELECT columns

FROM table1

INNER JOIN table2

ON table1.column = table2.column;