|
|
Cross JoinA Cross Join will result in a table that has every possible combination of the two tablesSELECT People.FName, TypePeople.CatName FROM People CROSS JOIN TypePeople THE SQL above will join two tables The tables may look like the following:
| ||||||||||||||||||
| The Resulting Table will look like this: | |||||||||||||||||||
| |||||||||||||||||||