
CREATE VIEW [dbo].[v_Sp2k_NonAcceptedTaxa]
AS

SELECT SPICE_Taxon.TaxonId, SPICE_Taxon.AccTaxonFk, 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
WHERE (((SPICE_Taxon.AccTaxonFk) Is Not Null))








GO
