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.