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;
‹ 2.1.18b. Outer joins
up
2.1.19. 2y and 3y joins ›
s5 slideshow