|
|
Right Outer JoinA Right Outer Join will take two tables and join them together based on the linking fieldA Right Outer Join will include ALL entries from the table on the RIGHT SELECT People.FName, People.LName, TypePeople.CatName FROM People RIGHT 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: | |||||||||||||||||||||||||
| |||||||||||||||||||||||||