If you use the SQL command line to mine the records in your tables, you’ll discover that a JOIN may be the best tool for finding the information you need. This week, I’ll explain the basic ...

If you only want to update values in table A when there are matching records in table B, then an inner join is the way to go. If you have calculations that need to vary based on optional data, the ...

In SQL parlance, this is called a "join." I do need to apologize to all the database pros at the gross simplification I used in this example. Table Join Example To demonstrate a join, I will show how ...

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.