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

[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