How to find “synonyms” in the Taxon tree

[eitan_m]

I’m looking for either a Specify query or an SQL query that lists all the taxonomic items in the Taxon tree that have a synonym associated to.
Thanks,
Eitan

[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

[eitan_m]

Thanks a lot Adam – it works and solves me the problem.

Eitan

[Author]

Posts