logo
  • About us
  • Services
  • Products
  • Work
  • Contact

Feedback

In Focus

  • Flash XML slideshow
  • Database training

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

    ‹ 2.1.18b. Outer joinsup2.1.19. 2y and 3y joins ›
    • s5 slideshow
     

     

     

    Copyright 2007 Lightenna Limited

    • About us
    • Services
    • Products
    • Work
    • Contact