View Single Post
  #10  
Old March 1st, 2009, 06:21 PM posted to microsoft.public.access.queries
[email protected]
external usenet poster
 
Posts: 308
Default Better "Join" vs "Where" clause?

Documentation is important. I'll add that thought as I try to improve.

Thanks EagleOne

Rick Brandt wrote:

On Sun, 01 Mar 2009 10:34:27 -0500, EagleOne wrote:

In my current situation, I do not need update-ability. But I have
learned quite a bit from the comments to my question. Thanks!


For many queries it comes down only to preference. I prefer join syntax
because that is more self-documenting about how the input sources
"relate" to each other leaving the WHERE clause to document selection
criteria.