> ## Content Index
> Fetch the complete content index at: https://nolongerset.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Throwback Thursday: July 11, 2024
- URL: https://nolongerset.com/throwback-thursday-2024-07-12/
- Published: 2024-07-12T01:35:00.000Z
- Updated: 2026-05-08T12:41:02.000Z
- Description: For those new to databases (and seasoned pros), queries are a mind-bogglingly amazing and infuriatingly obstinate tool. These tips help tame the beast.
- Author: Mike Wolfe
- Tags: Throwback Thursday, #Import 2026-05-20 02:59

*With over a million words scattered across more than 1,300 articles on this blog, you've probably missed a few things here.*

*That’s why each week in "Throwback Thursday," we’ll revisit some standout posts. Expect a blend of my personal favorites, insightful articles from other great minds, and a touch of coding humor to keep things light.*

---

## Highlights from NoLongerSet.com

[SQL Gotcha: When an OUTER JOIN Accidentally Becomes an INNER JOINIf you apply a WHERE filter directly to the OUTER JOIN side of a query you will effectively turn it into an INNER JOIN.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/06/homer.jpg)](https://nolongerset.com/filtered-outer-join/)

[3 Gotchas of the SQL BETWEEN StatementThe SQL BETWEEN statement produces very readable condition expressions. But developers of all skill levels can still get into trouble with it.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/12/petronas-911580_1920.jpg)](https://nolongerset.com/gotchas-of-the-sql-between/)

[How to Set a Breakpoint Inside of an Access QueryDid you ever want to set a breakpoint inside of an executing query? How about inside a form event property? This trick lets you do it.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/03/black-and-white-1282260_1920.jpg)](https://nolongerset.com/watch-this/)

[Fixing Circular References in Access QueriesDid you get the error message, “Circular reference caused by alias ‘MyField’ in query definition’s SELECT list”? Don’t worry; it’s an easy fix!![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/02/abstract-1438382_1920.jpg)](https://nolongerset.com/fixing-circular-references-in-queries/)

[Beware TempVars in QueriesMany Access users rave about using TempVars with queries. I decided to see what the hype was about. What I found shocked me.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/09/scam-4126798_1920.jpg)](https://nolongerset.com/beware-tempvars-in-queries/)

[Safely Using TempVars in QueriesCalling TempVars directly from a query can cause issues. Instead, use this simple wrapper function to save yourself some potential headaches.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/09/desktop-3207338_1920.jpg)](https://nolongerset.com/safely-using-tempvars-in-queries/)

## Wisdom from Around the Web

From the great Allen Browne:

[Microsoft Access tips: Why is my query read-only?List of reasons why a Microsoft Access query will yield non-editable results.![](http://allenbrowne.com/favicon.ico)](http://allenbrowne.com/ser-61.html)

[Microsoft Access tips: Surviving subqueriesTechniques to avoid 8 common errors, frustrations, limitations, and bugs when using subqueries in Microsoft Access.![](http://allenbrowne.com/favicon.ico)](http://allenbrowne.com/subquery-02.html)

[Microsoft Access tips: Optimizing queriesHow to get JET (the database engine in Microsoft Access) to execute queries quickly![](http://allenbrowne.com/favicon.ico)![](http://allenbrowne.com/graphics/cross.png)](http://allenbrowne.com/QueryPerfIssue.html)

## Developer Humor

> "What one programmer can do in one month, two programmers can do in two months." - Fred Brooks
> 
> — Programming Wisdom (@CodeWisdom) [August 16, 2023](https://twitter.com/CodeWisdom/status/1691701574085587285?ref%5Fsrc=twsrc%5Etfw)

*Cover image generated by Ideogram*