Hi. Just a guess, but maybe try removing the square brackets after the "as" for the alias. i.e. "...from snapshottable2 a st where..."
Thank you, that did not work. I have very similar code in other subqueries (select something from snapshottable2 as [st] where [st].[something]= etc) and it works OK, but this is the first time I used max in a subquery in recent memory.
use a query (not sql) and you wont get syntax errors.
Ha ha, yes, you make a fine point there.
But, coming up soon, I will be potentially using BASE SAS's
proc sql , and I have been doing anything that comes along to help me hone my skills in writing pure unadulterated ANSI SQL, which includes embracing Access subqueries, to the extent that THEY embrace ansi sql, which I believe they generally do.