/* This query selects all EOs with the selected edauthor names.
To change the edauthor, move down to the WHERE clause to make the
change. */

SELECT
SCIENTIFIC_NAME.SCIENTIFIC_NAME Scientific_name,
EO_SURVEY_SITE.SURVEY_SITE_NAME Survey_site,
D_BASIC_EO_RANK.BASIC_EO_RANK_CD EO_rank,
EO.LAST_OBS_DATE Last_Obs,
EO.DIRECTIONS Directions,
EO.VERSION_AUTHOR_NAME Edition_author,
EO.VERSION_DATE Edition_date,
EO.EO_ID

FROM
EO,
ELEMENT_SUBNATIONAL,
D_BASIC_EO_RANK,
SCIENTIFIC_NAME,
EO_SURVEY_SITE

WHERE
/* Change Weldy in the next line to the edauthor you wish to query.
Leave the quotes and wildcard (%) as they are. */

EO.VERSION_AUTHOR_NAME like 'Weldy%'and
EO.ELEMENT_SUBNATIONAL_ID= ELEMENT_SUBNATIONAL.ELEMENT_SUBNATIONAL_ID
and ELEMENT_SUBNATIONAL.SNAME_ID= SCIENTIFIC_NAME.SCIENTIFIC_NAME_ID
and EO_SURVEY_SITE.EO_ID = EO.EO_ID
and EO.D_BASIC_EO_RANK_ID = D_BASIC_EO_RANK.D_BASIC_EO_RANK_ID

/* Original query author: Troy Weldy, NY Natural Heritage Program
Created 29 August 2003
Modified by Charlene Houle September 2003.
Last modified by Troy Weldy on 16 October 2003 */