|
|
Left Outer JoinA Left Outer Join will take two tables and join them together based on the linking fieldA Left Outer Join will include ALL entries from the table on the LEFT SELECT People.FName, People.LName, TypePeople.CatName FROM People LEFT OUTER JOIN TypePeople on People.Category=TypePeople.ID THE SQL above will join two tables where People has a field in it(Category) linked to TypePeople(ID). The tables may look like the following:
| |||||||||||||||||||||||||||
| The Resulting Table will look like this: | ||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||