Revision 5670
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 2653 | 2653 |
-- |
| 2654 | 2654 |
|
| 2655 | 2655 |
CREATE VIEW tnrs_input_name AS |
| 2656 |
SELECT DISTINCT ON (taxonlabel.taxonomicname) taxonlabel.taxonomicname FROM (taxonlabel LEFT JOIN `TNRS`.tnrs ON ((tnrs.`Name_submitted` = taxonlabel.taxonomicname))) WHERE (((NOT (taxonlabel.taxonomicname IS NULL)) AND (taxonlabel.matched_label_id IS NULL)) AND (tnrs.`Name_submitted` IS NULL)) ORDER BY taxonlabel.taxonomicname;
|
|
| 2656 |
SELECT DISTINCT taxonlabel.taxonomicname FROM (taxonlabel LEFT JOIN `TNRS`.tnrs ON ((tnrs.`Name_submitted` = taxonlabel.taxonomicname))) WHERE (((NOT (taxonlabel.taxonomicname IS NULL)) AND (taxonlabel.matched_label_id IS NULL)) AND (tnrs.`Name_submitted` IS NULL)) ORDER BY taxonlabel.taxonomicname; |
|
| 2657 | 2657 |
|
| 2658 | 2658 |
|
| 2659 | 2659 |
-- |
| schemas/vegbien.sql | ||
|---|---|---|
| 3404 | 3404 |
-- |
| 3405 | 3405 |
|
| 3406 | 3406 |
CREATE VIEW tnrs_input_name AS |
| 3407 |
SELECT DISTINCT ON (taxonlabel.taxonomicname) taxonlabel.taxonomicname FROM (taxonlabel LEFT JOIN "TNRS".tnrs ON ((tnrs."Name_submitted" = taxonlabel.taxonomicname))) WHERE (((NOT (taxonlabel.taxonomicname IS NULL)) AND (taxonlabel.matched_label_id IS NULL)) AND (tnrs."Name_submitted" IS NULL)) ORDER BY taxonlabel.taxonomicname;
|
|
| 3407 |
SELECT DISTINCT taxonlabel.taxonomicname FROM (taxonlabel LEFT JOIN "TNRS".tnrs ON ((tnrs."Name_submitted" = taxonlabel.taxonomicname))) WHERE (((NOT (taxonlabel.taxonomicname IS NULL)) AND (taxonlabel.matched_label_id IS NULL)) AND (tnrs."Name_submitted" IS NULL)) ORDER BY taxonlabel.taxonomicname; |
|
| 3408 | 3408 |
|
| 3409 | 3409 |
|
| 3410 | 3410 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: tnrs_input_name: Use DISTINCT instead of DISTINCT ON because there is only one column