INNER JOIN
It is used to fetch the common data from the tables. It returns only that value when there is a matched column between them.
Syntax
SELECT column_name(s)
FROM table_nameA
INNER JOIN table_nameB ON table_nameA.column_name = table_nameB.column_name;
SELECT data from Multiple Tables in SQL
The statement is used to retrieve the fields from multiple tables and with the help of JOIN operations we easily fetch the records from multiple tables, Generally JOINS are used when there are common records between two tables. In this article, we will look into various types of JOIN that are used in SQL.