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

[Porter, Bill]

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:
[SUBDIVISION].[SUBDIVNAME] asc

But I want to enter an address which will query our Structures data, then take that point and collect data from map layers:
SchoolDistrict
City Council
USCongress
StateSenate
StateRep
Etc.
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: <http://lists.dep.state.fl.us/pipermail/shrug-l/attachments/20161028/ab1a7b36/attachment.html>