Inner Joins with examples

  Inner Join :   Inner join is used to  fetch the matching data from both the table.

Syntax :
 table1.column1 , table2.column , .................  from table1  inner join    table2  on   table1.column= table2.column;

Step 1:Create  a table  orders.

Step 2:  Create a  cust  Table:

Step 3:  Table design and data of  orders and cust Table.

Step 4:  Use  inner join

Here  orders  and cust is table name


 select  orders.orderid ,  cust.customerid ,  cust.cname ,  cust.Ccontact ,  cust.Country ,   orders.orderdate

 from    orders   inner join    cust  on     orders.customerid =  cust.customerid ;




Step 5:   Output of  inner join