Q&A
Ask and answer questions to make information more available to wider audiences.
answers 1
Answer 1
Ethan Barbrow
@ethanbarbrow 09, Aug 2023 03:25 PM
JOIN is used to retrieve data from two or more tables. By default, JOIN is also called INNER JOIN. It is used with SELECT statement.
There are mainly two types of joins in 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.
Syntax:
SELECT columns
FROM table1
INNER JOIN table2
ON table1.column = table2.column;