Tuesday, March 29, 2016

Two More SQL Query Articles that I recovered from the Smart Access Archives

Like most developers, you probably join tables in your queries by dragging a field from one table to a field in another table. While tremendously easy to do, this is just the tip of the proverbial join iceberg. There are at least two other ways of joining tables, and both let you do some neat things. Read the first of Peter Vogels articles here

In the second of the articles Peter discusses how to optimise queries for speed. There is a discussion on something called JETSHOWPLAN in the article.  Head to this page for links on ACCDB related registry keys, (I am guessing that they will work).



Garry Robinson
Access MVP 2006 - March 2016



No comments: