Specify the table(s) to be used in an SQL query.

      SELECT column(s) FROM table1 INNER JOIN table2 
         ON table1.field1 compopr table2.field2

   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.
(SQL) - Return the minimum value from a query.
Sum (SQL) - Add up the values in a query result set.

Copyright © 1999-2019
Some rights reserved