JOINS--continued

• Inner vs. Outer Joins

• Inner Join may cause “missing” data

• Left Outer Join includes all records from table on left

• New and Old Syntaxes:

• FROM Emp LEFT OUTER JOIN Depts ON

• FROM Emp E, Depts D WHERE

• E.DeptID = D.DeptID

Previous slide

Next slide

Back to first slide

View graphic version