Inner Join example in sql

Syntax: 
   SELECT t1.column_name,t2.column_name
   FROM table_name1 t1
   INNER JOIN table_name2 t2
   ON t1.column_name=t2.column_name

Example : 

  SELECT e.EmpName,e.EmpNo,o.OrderNo
  FROM EmpDetail e
  INNER JOIN OrderDetail o
  ON e.EmpID=o.EmpID