2.1.18c. Outer joins (cont)

  • Scale of loss isn't always instantly obvious
  • NULLs often used unpredicably
  • May want project information, even if no employee attached as manager
    • SELECT project.*, employee.*
    • FROM project LEFT OUTER JOIN employee
    • ON project.mgrssn = employee.ssn;

    Outer join example