
CREATE VIEW [dbo].[v_Sp2k_AcceptedTaxa]
AS

SELECT SPICE_Taxon.TaxonId, SPICE_TaxonID2HigherTaxonID.HigherTaxonID, SPICE_TaxonSearch.FullNameCache, SPICE_Taxon.Status, SPICE_Taxon.Rank, SPICE_Taxon.RankAbbrev, SPICE_TaxonSearch.NameCache, SPICE_Taxon.FullAuthorCache, SPICE_Taxon.FullSpeciesAuthorCache, SPICE_Taxon.Family, SPICE_Taxon.SupragenericName, SPICE_Taxon.Genus, SPICE_Taxon.SpeciesEpi, SPICE_Taxon.InfraSpeciesEpi, SPICE_Reference.RefId, SPICE_Reference.RefCache, RefDetail.RefDetailId, RefDetail.FullNomRefCache, SPICE_Reference.Title, SPICE_Reference.Author, SPICE_Reference.RefYear, RefDetail.Details
FROM (((SPICE_Taxon LEFT JOIN SPICE_Reference ON SPICE_Taxon.NomRefFk = SPICE_Reference.RefId) LEFT JOIN RefDetail ON SPICE_Taxon.NomRefDetailFk = RefDetail.RefDetailId) INNER JOIN SPICE_TaxonSearch ON SPICE_Taxon.TaxonId = SPICE_TaxonSearch.TaxonId) LEFT JOIN SPICE_TaxonID2HigherTaxonID ON SPICE_Taxon.TaxonId = SPICE_TaxonID2HigherTaxonID.TaxonID
WHERE (((SPICE_Taxon.Status)='accepted'))







GO
