How to find “synonyms” in the Taxon tree

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

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #5465
    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

    #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

    #5469
    eitan_m

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

    Eitan

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.