Revision 7138
Added by Aaron Marcuse-Kubitza over 11 years ago
| schema.sql | ||
|---|---|---|
| 115 | 115 |
, tnrs_accepted."Source" AS "Accepted_name.Source" |
| 116 | 116 |
, tnrs_accepted."Warnings" AS "Accepted_name.Warnings" |
| 117 | 117 |
, tnrs_accepted."Accepted_name_lsid" AS "Accepted_name.Accepted_name_lsid" |
| 118 |
, tnrs_accepted."Accepted_scientific_name" AS "Accepted_name.Accepted_scientific_name" |
|
| 118 | 119 |
FROM tnrs |
| 119 | 120 |
LEFT JOIN tnrs tnrs_accepted ON |
| 120 | 121 |
tnrs_accepted."Name_submitted" = tnrs."Accepted_scientific_name" |
Also available in: Unified diff
inputs/.TNRS/schema.sql: tnrs+accepted: Added new Accepted_scientific_name column and mapped it in public.unscrubbed_taxondetermination_view