Re: Selection of groups in SQL
Is there an obvious way to filter by groups (I know this can be done in Recorder 6) using MS SQL Server Management Express?
I'm really thinking about in the WHERE clause of an SQL Query, other than by typing in a long list of species as below?
WHERE INDEX_TAXON_NAME.PREFERRED_NAME = 'Enallagma cyathigerum'
OR INDEX_TAXON_NAME.PREFERRED_NAME = 'Pyrrhosoma nymphula'
OR INDEX_TAXON_NAME.PREFERRED_NAME = 'Ischnura elegans'
OR ...
...OR INDEX_TAXON_NAME.PREFERRED_NAME = 'Leucorrhinia dubia';