Reply To: How to find “synonyms” in the Taxon tree

Home Forums User Forum How to find “synonyms” in the Taxon tree Reply To: How to find “synonyms” in the Taxon tree

#5468
arountre

If you just want the non-preferred synonyms:
SELECT * FROM specify.taxon WHERE AcceptedID IS NOT NULL;

If you want the preferred and non-preferred:
SELECT * FROM specify.taxon WHERE TaxonID IN (SELECT AcceptedID FROM specify.taxon WHERE AcceptedID IS NOT NULL) OR AcceptedID IS NOT NULL;

-Adam