Specify the type of join and the join criterion. The FROM clause lists the tables to join and assigns table aliases. The keywords LEFT JOIN specify the type of join. The ON clause specifies that the join is based on the ID numbers from each table.


      from proclib.payroll p left join proclib.payroll2 p2
      on p.IdNumber=p2.idnum;