To this day I find it irritating that MS Access requires this syntax:

SELECT * FROM (SELECT FOO, BAR, BAZ FROM SNERVITZ WHERE FOO<>"TOTALWASTE") AS LIPSNERS INNER JOIN (SELECT BIZ, BAM, ZOO FROM BLERWHOT WHERE BIZ<>"JERKAZOIDAL") ON FOO=ZOO WHERE BAR>BAM;

...when writing a query but this syntax...

SELECT * FROM [SELECT FOO, BAR, BAZ FROM SNERVITZ WHERE FOO<>"TOTALWASTE"; ] AS LIPSNERS INNER JOIN [SELECT BIZ, BAM, ZOO FROM BLERWHOT WHERE BIZ<>"JERKAZOIDAL"; ] ON FOO=ZOO WHERE BAR>BAM;

...when running it. The end result meaning that every time I open and edit any such nested query I break it, have to fix the syntax to the first form, and as soon as I close it it is recompiled into the second such that it will run. But, again, the next time I have to edit it it will complain that it has syntax errors.

WHO DID THIS? WHO?

Regardless, when I complain that Access is broken, this is the type of thing that I am referring to.

--random