AS [%$##@_Alias]?

[robdunfey]

Hi-

Could someone please explain what the AS [%$##@_Alias] refers to in this query? It works but isnt the name of a table or query in the database?

Any indication, much appreciated,

Rob


SELECT DISTINCT SITE
FROM [SELECT SITE, ID, count(*)
FROM L_ALL
GROUP BY SITE, ID
HAVING count(*) > 1]. AS [%$##@_Alias];

 

[SteveR77]

Rob,

If I am not mistaken the [%$##@_Alias] is an internal reference that MS Access uses to create the headings for the GROUP BY query such as Count of Site ID.


HTH,

Steve

 

[oharab]

It's actually a query within a query.

Basically a query called %$##@_Alias is created with the SQL

SELECT SITE, ID, count(*)
FROM L_ALL
GROUP BY SITE, ID
HAVING count(*) > 1

then another query is based on that query.

It's an integrated version of having 2 seperate queries.

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"

NoFX-The Decline
----------------------------------------------