That’s got it at last! ~ Amy
Amy E. Hodge, PhD Science Data Librarian [email protected]<mailto:[email protected]> 650.556.5194 [cid:[email protected]] orcid.org/0000-0002-5902-3077<https://orcid.org/0000-0002-5902-3077> Data Management Services Branner Earth Sciences Library, 212 Mitchell 397 Panama Mall; MC 2211 Stanford University Stanford, CA 94305 From: "David Martin (Staff)" <[email protected]> Date: Friday, October 20, 2017 at 4:39 PM To: "Amy E. Hodge" <[email protected]>, "[email protected]" <[email protected]> Subject: Re: SQL IFNULL question SELECT surveys.plot_id, species.genus, count(species.genus) as observations FROM surveys JOIN species ON IFNULL(surveys.species_id,'UR') = species.species_id GROUP BY surveys.plot_id, species.genus;
_______________________________________________ Discuss mailing list [email protected] http://lists.software-carpentry.org/listinfo/discuss
