MariaDB Inner Join

by Online Tutorials Library July 14, 2022

MariaDB Joins

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 (Also called SIMPLE JOIN)
MariaDB LEFT OUTER JOIN (Also called LEFT JOIN)
MariaDB RIGHT OUTER JOIN (Also called RIGHT JOIN)

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:

Image representation:

MariaDB Join 1

Example:

We have two tables “Students” and “Employee2”.

Student table:

MariaDB Join 2

Employee2 Table:

MariaDB Join 3

Use the following syntax to join both table according to given parameters:

 SELECT Students.student_id, Students.student_name, Employee2.salary FROM Students  INNER JOIN Employee2 ON Students.student_id = Employee2.emp_id;  

Output:

MariaDB Join 4

You can combine as many fields as you want. Let?s add some more fields:

 SELECT Students.student_id, Students.student_name, Students.student_address, Employee2.salary FROM Students  INNER JOIN Employee2 ON Students.student_id = Employee2.emp_id;  

Output:

MariaDB Join 5

Next TopicMariaDB Left Outer Join

MariaDB Inner Join

MariaDB Joins

MariaDB INNER JOIN

Smoke Testing

Traditional Marketing

You may also like