Structured Query Language (SQL) Tutorials

Inner Join

An Inner Join will take two tables and join them together based on the linking field

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

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

Come learn HTML or Classic ASP in Honolulu, Hawaii!