'$RCSfile: eml-view.xsd,v $' Copyright: 1997-2002 Regents of the University of California, University of New Mexico, and Arizona State University Sponsors: National Center for Ecological Analysis and Synthesis and Partnership for Interdisciplinary Studies of Coastal Oceans, University of California Santa Barbara Long-Term Ecological Research Network Office, University of New Mexico Center for Environmental Studies, Arizona State University Other funding: National Science Foundation (see README for details) The David and Lucile Packard Foundation For Details: http://knb.ecoinformatics.org/ '$Author: obrien $' '$Date: 2008-11-14 23:50:13 $' '$Revision: 1.43 $' This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA eml-view

The eml-view module describes a view from a database management system. A view is a query statement that is stored as a database object and executed each time the view is called.

all datasets that contain one or more views yes View The View element is a container for documenting a view. The View element is a container for documenting a view. The structure of the view element is defined by the ViewType. ViewType The ViewType complex type defines the structure for documenting a view. The ViewType complex type defines the structure for documenting a view. This type extends the EntityGroup with a queryStatement. Attribute List The list of attributes associated with this entity. The list of attributes associated with this entity. For more information see the eml-attribute module. Constraint Description of any relational constraints on ' this entity. For more information see the eml-constraint module. Query Statement Query syntax that produced the view The value of a queryStatement field is the actual query statement stored in the database is entered here. The query statement generates the entity being documented. Select site as SiteID,common_name as CommonName, count as CountOfIndividuals from samples inner join taxonlist on samples.speciesid=taxonlist.speciesid