About us
What we do
Our product
Recent 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
