Left Outer Join
The result consists of rows from the DEPT paired with rows from EMP and, for each unpaired row of DEPT, the concatenation of that row with the
null
row of EMP.
©Copyright 1996 Chuck Anesi all rights reserved