What is an inner join in SQL?
Inner Join:-
It returns only matching rows from both the tables.
Syntax:-
Select a.column1,a.column2,b.column1,b.column2
from table1 as a INNER JOIN table2 as b
on a.Common_field = b.Common_field
Example:-
SELECT a.OrderID, b.CustomerName
FROM Orders as a
INNER JOIN Customers as b
FROM Orders as a
INNER JOIN Customers as b
ON a.CustomerID = b.CustomerID;