Specify the type of join. The FROM clause lists the tables to join and assigns table aliases. The keywords LEFT JOIN specify the type of join. The order of the tables in the FROM clause is important. PROCLIB.PAYROLL is listed first and is considered the "left" table. PROCLIB.PAYROLL2 is the "right" table.


      from proclib.payroll as p left join proclib.payroll2 as p2