Full Outer Join example in sql

Syntax :
   SELECT Column_List FROM table_name1 t1
   FULL OUTER JOIN table_name2 t2
   ON t1.column_name=t2.column_name


Example :

  SELECT e.EmpID,e.EmpName,o.OrderNo
  FROM EmpDetail e
  FULL OUTER JOIN 

  OrderDetail o
  ON e.EmpID=o.EmpID