Check out example codes for "inner join sql". It will help you in understanding the concepts better.

Code Example 1

SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;

Code Example 2

SELECT column_name(s)

FROM table1

INNER JOIN table2
 ON table1.column_name = table2.column_name;

Code Example 3

SELECT Orders.OrderID, Customers.CustomerName
FROM Orders
INNER JOIN 
  Customers ON Orders.CustomerID = Customers.CustomerID;

Code Example 4

SELECT Orders.OrderID, Customers.CustomerName, Shippers.ShipperName
FROM 
  ((Orders
INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID)

  INNER JOIN Shippers ON Orders.ShipperID = Shippers.ShipperID);

Code Example 5

SELECT column-names  FROM table-name1 JOIN table-name2     ON column-name1 = column-name2 WHERE condition

Code Example 6

SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate
FROM Orders
INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID;

Learn ReactJs, React Native from akashmittal.com