CREATE VIEW all__species AS
SELECT  tax__family.family,
	    tax__genus.genus,
        tax__species.species
FROM    tax__species 
LEFT JOIN tax__genus ON tax__genus.genus = tax__species.genus
LEFT JOIN tax__family ON tax__family.family = tax__genus.family