[Database Abstract] 6_ SQL _Inner_Join

The INNERJOIN operator returns a row if at least one matching keyword exists in the table. SQLINNERJOIN syntax SELECTcolumn_name (s) FROMtable1INNERJOINtable2ONtable1. column_nametable2.column_name; or: SELECTcolumn_name (s) FROMtable1JOINtable2ONtable1. co

The inner join operator returns a row if at least one matching keyword exists in the table. SQL INNER JOIN syntax SELECT column_name (s) FROM table1INNER JOIN table2ON table1.column _ name = table2.column _ name; or: SELECT column_name (s) FROM table1JOIN table2ON table1.co

Inner join Operator

The inner join keyword returns a row if there is at least one match in the table.

SQL INNER JOIN syntax

SELECT column_name(s)FROM table1INNER JOIN table2ON table1.column_name=table2.column_name;

Or:

SELECT column_name(s)FROM table1JOIN table2ON table1.column_name=table2.column_name;

Note: inner join and JOIN are the same (intersection ).

Demo

SELECT Customers.CustomerName, Orders.OrderIDFROM CustomersINNER JOIN OrdersON Customers.CustomerID=Orders.CustomerIDORDER BY Customers.CustomerName;

Mysql

You can also use the following method, which is equivalent to the following:

SELECT Customers.CustomerName, Orders.OrderIDFROM Customers , OrdersWHERE  Customers.CustomerID=Orders.CustomerIDORDER BY Customers.CustomerName;    

You can also visit: http://txidol.github.io for more information