"When joining tables on common fields, if you're not diligent in
the use of AND-OR combinations in the criteria clause, be prepared
for unexpected results! Learn how to break filtering criteria into
individual steps and how to group AND-OR statements to most
effectively isolate the data that you wish to retrieve.
"The following code can be used to create and populate the
employees and shops tables. If you've downloaded the table data
from my recent articles, you don't need these as they are the