Joins Specified in the WHERE clause

With Microsoft Jet, you can create relational joins in SQL by specifying the linking condition in the WHERE clause:

SELECT 
	Products.ProductID, 
	Products.ProductName, 
	Categories.CategoryID, 
	Categories.CategoryName
FROM Categories, Products
WHERE Products.CategoryID = Categories.CategoryID;

This query uses two fields each from the Products and Categories tables and selects records from each table where the CategoryID field in Products matches the CategoryID field in Categories.