Specify the table(s) to be used in an SQL query.
Syntax SELECT column(s) FROM table1 INNER JOIN table2 ON table1.field1 compopr table2.field2 Key table1, table2 The tables from which records are combined. field1, field2 The fields to be joined. The fields must be of the same data type and contain the same kind of data, but they do not need to have the same name. compopr Any relational comparison operator: = < > <= >= or <>
' In SQL SELECT CategoryName, ProductName
FROM Categories INNER JOIN Products
ON Categories.CategoryID = Products.CategoryID;
“Never was anything great achieved without danger” ~ Niccolo Machiavelli
DCount - Count the number of records in a table/query.
Avg (SQL) - Average
Max (SQL) - Return the maximum value from a query.
Min (SQL) - Return the minimum value from a query.
Sum (SQL) - Add up the values in a query result set.