shrug-l: SQL query to drill into mulitple layers and report back in tablular form

Porter, Bill bporter at
Fri Oct 28 11:57:25 EDT 2016

I am new to SQL.  I'm using FREEANCE to query and to render maps from ArcServer.
I can create basic SQL queries,  like one to bring up a  subdivision name if you can spell a portion of it:

[SUBDIVISION].[SUBDIVNAME] like '%#@^subdivname@#%'
                                             Then create ascii listing for it:

But I want to enter an address which will query our Structures data, then take that point and collect data from map layers:
City Council
And return that data in an ASCII listing.

Does anyone have an example of a query like this? I have no idea how to nest requests in SQL.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the SHRUG-L mailing list