...
For getting the full scientific name
| Code Block | ||
|---|---|---|
| ||
--This are the columns needed
concat_ws(' ', fl."GENUS",fl."SP",fl."ISP1RANK",fl."ISP1",fl."ISP2RANK",
fl."ISP2",fl."ISP3RANK",fl."ISP3",fl."SPAUTHOR",fl."ISP1AUTHOR",
fl."ISP2AUTHOR",fl."ISP3AUTHOR") as species_name,
--and the join is made on the suspecies and flspflvnonsynnotren tables
join bdbsa.flspflvnonsynnotren fl on fl."NSXCODE" = spp."NSXCODE" |
...