Revision 6760
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/CVS/stemCount_/create.sql | ||
|---|---|---|
| 1 |
SELECT * |
|
| 2 |
FROM "taxonImportance" |
|
| 3 |
LEFT JOIN "stemCount" USING ("taxonImportance_ID")
|
|
| 4 |
; |
|
Also available in: Unified diff
inputs/CVS/: Joined together taxonImportance and stemCount tables to create stemCount_, because stemCount actually stores stem abundance by size, rather than grouping stems by organism (http://vegbankdev.nceas.ucsb.edu/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename), and is thus an AggregateOccurrence-related table along with taxonImportance