Structured Query Language (SQL) Tutorials

Full Join

A Full Join will take two tables and join them together based on the linking field

A Full Join will include ALL entries from both tables

SELECT People.FName, People.LName, TypePeople.CatName FROM People FULL 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:

People
FName	LName	Category
John	Smith	1
Al	Jones	2
Jim	Brown	4

TypePeople
ID	CatName
1	Employee
2	Customer
3	Supplier

The Resulting Table will look like this:

RESULT
FName	LName	CatName
John	Smith	Employee
Al	Jones	Customer
NULL	NULL	Supplier
Jim	Brown	NULL

Come learn HTML or Classic ASP in Honolulu, Hawaii!