Clarify the docs: Advanced SQL syntax is supported in FGDB views and expression subqueries

[Bud]

It looks like we can use advanced SQL syntax such as GROUP BY and HAVING in FGDB views and FGDB expression subqueries.

For example, I can create a FGDBviewlike this:

select text_a from table_agroup bytext_a
having
1=1
--I can useJOIN in FGDB views too.

And I can create an FGDBSQL expression subquerylike this:

id_a in (select id_b from table_bgroup byid_bhaving1=1)

I'm aware that the above example queries are fake/not terribly useful. They're just meant to demonstrate that the SQL syntax is valid.

Idea:

据我所知,文档也't mention that the above syntax is valid in FGDB views and subquery expressions. Could the docs be improved?

I'm aware of the SQL syntax mentioned in this page:SQL for reporting and analysis on file geodatabases．但是如果我理解correctly, the syntax on that page pertains specifically to the .NET API/ArcObjects, not SQL syntax for FGDB views or expressions.