sample SQL for EO delimlists for COUNTY, MAPSHEET, WATERSHED, MA_NAME, CITATIONS, and OWNER_TYPE
You should be able to insert the delimlists into the "SELECT" portion of any EO query. The delimlists are self-contained mini queries and the tables in the delimlists do not need to appear anywhere else in the query. Most of these use the _dvw view tables which display the domain values. If you want a different value - say just the watershed code you can edit the "select" section within the delimlist to display a different field.
AUTHOR: Lynn Kutner, NatureServe
DATE: August 24, 2004

SELECT eo.eo_id,
DelimList('SELECT county FROM eo_county_dvw WHERE eo_id='||eo_id, '; ') AS counties,
DelimList('SELECT mapsheet FROM eo_mapsheet_dvw WHERE eo_id='||eo_id, '; ') AS quads,
DelimList('SELECT watershed FROM eo_watershed_dvw WHERE eo_id='||eo_id, '; ') AS watersheds,
DelimList('SELECT ma.managed_area_name FROM ma, eo_managed_area eoma' ||
' WHERE ma.managed_area_id = eoma.managed_area_id AND eoma.eo_id=' || eo.eo_id, '; ') AS ma_name,
DelimList('SELECT ref.reference_code || '': '' || ref.formatted_full_citation FROM reference ref, eo_reference eoref'
|| ' WHERE ref.reference_id = eoref.reference_id AND eoref.eo_id=' || eo.eo_id, ' * ') AS citations,
DelimList('SELECT d_owner_type.owner_type_cd FROM d_owner_type, eo_owner eoown'
|| ' WHERE d_owner_type.d_owner_type_id = eoown. d_owner_type_id AND eoown.eo_id=' || eo.eo_id, '; ') AS eo_own

FROM eo,
element_subnational,
subnation

WHERE eo.element_subnational_id = element_subnational.element_subnational_id
and element_subnational.subnation_id = subnation.subnation_id